I normally use Excel to calculate my current grade in a class but I am wondering if there is any way to ignore a weight in a calculation? (for example, ignore the 20% I have listed for Final Exam, as I clearly won't need that in a calculation because I will not have that grade until the end of the semester)



Right now, the formula I have with the Final Grade takes into account all of the weights, so the grade is marginally lower because it is still taking the weight into account and essentially substituting a zero in when the grade cell is blank. Is there any way to fix this so that, for example, if I only had a 90 in one section, attendance for example, the grade would be 90 and not 13.5 (90*.15, the weight)? Attached is a .png of my sheet right now.

I also understand why I have div/0 errors, as I have no grades in for the cells that those cells with an error are averaging.

Attached Images

Screen Shot for Excel.png (57.5 KB, 17 views)

Hi and welcome
could you please explain another way what you are trying to do ?
I don' understand at all. ( and also posting a sheet instead of an image helps)

__________________
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