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
|