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)