In A1 enter 85 (your current grade)
In B1 enter 80% ( your current percentage)
In C1 enter 90 ( the minimum grade needed for an A)
In D1 enter:
=(C1-A1*B1)/(1-B1)
This displays more than 100 and therefore you cannot get an A. In fact if your final 20% grade was 100, the overall average would be only 88%
Next change C1 to 81 (the minimum grade needed for a B)
Now D1 displays 65. This means that even if the final 20% was as low as 65, your overall average is 81 and you get the B
Gary's Student
Yes! That works! Thanks. To clarify for each of the two examples:
In the first one, I think the semester exam only goes into the 2nd sem grade, so the grade I have for the 2nd semester would be worth 80% and the exam would be worth 20%. That would give me the whole 2nd semester grade. From there, I could easily find my final grade by just mutipling e3ach by 50% and then adding them together.
I actually used this formula:
=(C1-(A1*0.8))/(1-0.8) since my A1 was equal to 80% of the grade. So if I got C1 for my final exam grade for example, then for the Final Yearly grade I would just multiply the 1st semester grade by the 2nd sem grade.
And for the 2nd scenario, I used this formula
=((C1-(($A1*0.4)+($A2*0.4)))/(1-0.8)), where A1 was my grade for the 1st sem (worth 40%), A2 was the grade for the 2nd sem (worth 40%) and C1 (worth 20%) was the grade if I was to make an A or B or C....
Actually, writing it out like this, maybe I need to submit a page with some info so that you can check it. Do you think or can you tell without it? If so, then I can do it in an hour or two.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks