Comparing a value and outputing a result to a cell
Posted by Sean Webb on June 23, 2001 1:26 AM
Okay, I am working on a grading system for my pupils. Their progress is worked out by comparing their actual level to their predicted level, now this bit I can do.
The bit I cannot do is to take that comparison and turn it into a grade.
If the comparison is <0.25 then their progress is PC
If the comparison is <0.5 then their progress is PS
If their progress is <0.75 then their progress is PG
How do I use the comparison to output a grade into a cell ? any help would be appreciated.