Converting a numeric score to letter grade
Posted by Dan on July 11, 2001 6:49 PM
I have a list of final marks from a test and I want to
convert them to a letter grade acording to a formula (ie.
<50 is "F", >50 and <60 is "P", >60 and < 70 is "C"..etc.)
How do I perform this "if-then-else" task? I would rather
not used a vertical lookup table with 100 rows. Is there
a formula I can use?
Dan.