Thread: How to get value through a matrix?
View Single Post
 
Old 10-20-2014, 11:39 PM
Xemx Xemx is offline Windows 8 Office 2007
Novice
  
Join Date: Oct 2014
Posts: 2
Xemx is on a distinguished road
Default
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?
Reply With Quote