#1




How to get value through a matrix?
The BOLD box needs to provide us with the combined result of the following;
 When inputting the scale level within the 'Sample Point' section (ie:K9 & K10), the formula will use both values to determine; the multiplication range highlighted in the Matrix for the number of ECTS (ie: Scale level 5 by 20 ECTS should; Multiply the first 10 ECTS by 30, and the second 10 ECTS by 15 for a total of 450). How can we go about this? 
#2




The 450?
Quote:
Quote:
The value you want to calculate is 450? Is this directly from 6*75? 
#3




Yes, basically I need to design a formula which will;
 select the range in which the number listed in the Scale level fits in the matrix.  then have the multiplication done according to the Number of ECTS by the stipulated range values ie: The first 10 ECTS need to be multiplied by the first Column, the next 20 ECTS need to be multiplied by the second column and so forth... Does it make sense? 
#4




Quote:
Quote:
Quote:

Tags 
define, how to, matrix 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
How to create a matrix of formulas  atis  Excel  3  05302014 08:48 AM 
making correlation matrix  Ridgerunner  Excel  3  03222013 07:09 AM 
Dot Matrix Printing  Angela  Office  2  05152012 08:56 PM 
Matrix Algebra  judicial85  Excel  3  10122011 05:41 PM 
From Outlook to Dot Matrix Printer  ihightower  Outlook  0  10042010 09:15 AM 