Test 1 Test 2 HW Final Grade
Percent 20% 20% 25% 35% 100%
Grade 55 100 36
X=B7*0.2+C7*0.2+D7*0.25+E7*0.35
I have this spreadsheet set up to calculate my grade in each class. Here is an example of the sheet and the code.
Right now, the grade currently gives me my average out of 100%. For instance, you can see it says i have a 36% by calculating 100*0.25 + 55*0.2.
Is there a function i can use that would omit those blank cells until value was entered? In other words, with the above values, is there a way for that "grade" column to read 80? (which is my current average), but then change when I enter another test score to only average those 3?
Percent 20% 20% 25% 35% 100%
Grade 55 100 36
X=B7*0.2+C7*0.2+D7*0.25+E7*0.35
I have this spreadsheet set up to calculate my grade in each class. Here is an example of the sheet and the code.
Right now, the grade currently gives me my average out of 100%. For instance, you can see it says i have a 36% by calculating 100*0.25 + 55*0.2.
Is there a function i can use that would omit those blank cells until value was entered? In other words, with the above values, is there a way for that "grade" column to read 80? (which is my current average), but then change when I enter another test score to only average those 3?
Last edited: