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.
For example
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.
Posted by Aladin Akyurek on June 23, 2001 1:47 AM
With VLOOKUP
Sean
The following will produce intended grading:
=VLOOKUP(A1,{0,"PC";0.25,"PS";0.5,"PG";0.75,"OKAY"},2,1)
You didn't say what the grade will be when the comparison value 0.75 and higher. So I cooked up "OKAY" as grade for such cases.
Aladin
================
Posted by Sean Webb on June 23, 2001 2:03 AM
Re: With VLOOKUP
Thank you very much.
Sean
