Quote:
Originally Posted by Xemx
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.
|
The scale level is 6. This is just selected by the user? And this points to the table to the left where 1-10=30, 11-30=15, and >31=5.
Quote:
|
- 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...
|
So you have 75 ECTS, then what? 1-10 are multiplied by 30, 11-30 are multiplied by 15, and 31-75 are multiplied by 5? That comes to 825, not 450.
Not exactly.