Excel formula to calculate Target Grade

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)

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" <harleypop@discussions.microsoft.com> wrote in message
news:D0403761-B6C9-44E4-9987-7234E7C01DDC@microsoft.com...
> 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)

Thanks for your help..

"Tom Ogilvy" wrote:

> 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" <harleypop@discussions.microsoft.com> wrote in message
> news:D0403761-B6C9-44E4-9987-7234E7C01DDC@microsoft.com...
> > 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)
>
>
>