Register now or log in to join your professional community.
What will be the formula for assigning Grades in Column B ? If Column A = marks i.e.72 Grade scale: >=92 "A+" >=82 "A" >=72 "B+" >=65 "B" >=55 "C+" > =48 "C" >=40 "D" >=35 "E" <35 "F"
Usually the IF formula is used for such calculations, however a vlookup formula can be applied instead as it is short and easy to do.
The formula in column B would be: =IF(ISBLANK(A2),"",(VLOOKUP(A2,$E$2:$F$10,2,TRUE)))
Kindly check the image below, just type the grading in a separate area and use the above formula with "approxiamte match"
Thanks,
You're Gonna Like It ,
A13 Is The Student Grade
=IF(A13>=92,"""A+"" ",IF(A13>=82,"""A"" ",IF(A13>=72,"""B+"" ",IF(A13>=65,"""B"" ",IF(A13>=55,"""C+"" ",IF(A13>=48,"""C"" ",IF(A13>=40,"""D"" ",IF(A13>=35,"""E"" ",IF(A13<35,"""F""","")))))))))
