Formula Help - Current Final Grade

Hi ExcelStudent187,

Attached please find the very control approach to your question. I tested it out and I think it is working as you requested. Definitely please let me know if it what you expected.

Hope it helps,

Raymond

PS - The nested-formula was the initial approach I took. But I am sure there has to be an easier way.

AttachmentSize
Grade Sheet Problem (RReyes).xlsx14.85 KB