exam marks into grades
=IF(A1<40,"FAIL",LOOKUP(A1,{40,60,70,80},{"D","C", "B","A"}))
Get rid off IF()
=LOOKUP(A1,{0,40,60,70,80},{"FAIL","D","C","B","A" })
"Jacob Skaria" wrote:
Will this help. With marks in A1
=IF(A1<40,"FAIL",LOOKUP(A1,{40,60,70,80},{"D","C", "B","A"}))
--
If this post helps click Yes
---------------
Jacob Skaria
"Sharon R" wrote:
How do I convert exam marks into grades using spcified grade boundaries?
|