MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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