Need (Excel) formula to make Mark sheet with Automatic Grading
On Saturday, 20 September 2008 18:07:10 UTC+5:30, wrote:
Hi,
I agree VLOOKUP; however, the lookup table should be set as follows:
Mark Grade
0 Not Graded
40 F
50 E
60 D
70 C
80 B
90 A+
Headers are optional
Alternatively if you want to use a formula the following one can be
placed in D2 and copied down.
=IF(C2=90,"A
+",IF(C2=80,"B",IF(C2=70,"C",IF(C2=60,"D",IF(C2 =50,"E",IF(C2=40,"F","Not
Graded"))))))
Cheers
|