Hi all,
I need to create 1 grade item column/row to calculate "grade point".
The calculation goes as:
Marks Range Grade Point
80-100 5
70- 79 4
60- 69 3.5
50- 59 3
40- 49 2
33- 39 1
0- 32 0
I tried to follow the example "if formula" given at Moodle docs but didn't succeed as it shows "invalid formula" when applied.
I put into the calculation box: =if(1, 2, 3<=32%, 0, 1,2,3<=39%, 1, etc)
as I have 3 columns to calculate with id numbers 1, 2 , 3.
Would anybody do me favour by guiding/writing the formula?
Thank you in advance.