CASE By Itself
=IF(K2>20.5,"A*",IF(K2>17.5,"A", IF(K2>15.5,"B",IF(K2>12.5,"C", IF(K2>10.5,"D",IF(K2>8.5,"E", IF(K2>6.5,"F",IF(K2>5.5,"G","U"))))))))
INVESTIGATION
=IF(AA2>35.5,"A*",IF(AA2>31.5,"A", IF(AA2>27.5,"B",IF(AA2>23.5,"C", IF(AA2>19.5,"D",IF(AA2>15.5,"E", IF(AA2>11.5,"F",IF(AA2>7.5,"G","U"))))))))
CASE plus I&E
=IF(Q2>35.5,"A*",IF(Q2>31.5,"A", IF(Q2>27.5,"B",IF(Q2>23.5,"C", IF(Q2>19.5,"D",IF(Q2>15.5,"E", IF(Q2>11.5,"F",IF(Q2>7.5,"G","U"))))))))
Cells K2,AA2 and Q2 are just where your total mark is on the spreadsheet. This is just for information on how the grades are worked out on SIMs worksheets.
