How is the end of the year grade calculated. Assume each test is of equal
weight, then how many test have contributed to your current grade.

Assume you take 9 tests, so 2 have been taken and average to 94.1. Then the
final grade would be

Sum of 9 grades / 9 = final grade

sum of all tests = 9 * 96.5


average needed per remaining test = ((96.4 * 9) - (94.1 * 2))/7 = 97.1

--
Regards,
Tom Ogilvy





"harleypop" wrote in message
...
Problem:
Current Grade 94.1 - Target Grade 96.5

I need a formula that will calculate what grade is needed to maintain to
achieve target grade from current grade. Their is only 7 months left and
only 1 test per month.

So what grade do I need to maintain to achieve my goal grade at the end of
the year? (Excel Formula)