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

Help me see what I am missing, it still doesn't do what I need.

Checking there is a student for the row by seeing if D3 has an ID number
--> If false, output ""
--> If true, check if each cell of range Q:AG is above 69.5 (ignoring blank cells),
--> if false, output "F"
--> if true, output the letter grade based on the average in AH

Sounds so simple but is driving me crazy.

Thank you for your patience,
David

Attached Files

2016-04-09SPR-001_TEMPLATE_c.xlsx (86.2 KB, 11 views)

If I have understood you correct.

Attached Files

2016-04-09SPR-2.xlsx (86.5 KB, 9 views)