Currently, i've done this
=IF(H3>=101,"ERROR",IF(H3>=70,"A",IF(H3>=60,"B",IF(H3>=50,"C",IF(H3>=40,"D",IF(H3<=39,"FAIL","ERROR"))))))
which works, its a calculation for a full module grade.
but the problem comes if I calculate 1/2 modules where i have to add both marks together and get a grade, but If i was to type anything else other than 1-100, I would want it to show the word "error" help!
Bookmarks