Please see attached

The only things that you have to check is the range that needs to be controlled for values <69.5 ( just adapt it) and if the AH cell is the one to be tested to obtain the grade (change it in the LOOKUP function if need be)

Attached Files

Copy of 2016-04-09AMT-SPR-001_TEMPLATE_b.xlsx (89.2 KB, 10 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post