Need (Excel) formula to make Mark sheet with Automatic Grading
Dear Steve "Cheers"
Many thanks for below formula !!! It's working ..
=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"))))))
But I found some problem in Grading in Vlookup formula ... explain below:
SL. # Subject Marks Grade
1 AA 91 A+
2 AB 79 C
3 AC 81 C it should be "B" as per range
4 AD 70 D it should be "C" as per range
5 AE 50 F it should be "E" as per range
Range of Grade
40-49 F
50-59 E
60-69 D
70-79 C
80-89 B
90-99 A+
Looking forward for your favorable response.
Regards
Hina
" 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
|