Formula Help| Finding Time depending on attempts

[Rara1424]

Hi Guys,

I have a table like this:

[TABLE="width: 437"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Current Attempts[/TD]
[TD]Current Average Time[/TD]
[TD]Goal[/TD]
[TD]Remaining Attempts[/TD]
[TD]Time I need to get to goal[/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD]250.00[/TD]
[TD]210.00[/TD]
[TD]25.00[/TD]
[TD]> help here <


[/TD]
[/TR]
</tbody>[/TABLE]
I'm looking for a formula on how much time I need to get to my goal. Math is not really my thing so I'm resorting to excel. Thanks guys.

 

[levy77]

Hi Rara,

Try this formula
=(C2*(A2+D2)-A2*B2)/D2

 

[DSCfromCFA]

The formula you are looking for is
((Total Number of attempts * Goal) - (Current Number of Attemps * Current Average)) / Remaining Attempts

Using your numbers

((75*210.00) - (50*250.00)) / 25 = 130.00. You must average 130.00 on your remaining 25 attempts to achieve an overall average of 210.00

And if your data row starts in Cell A2 the formula in E2 would be
=(((A2+D2)*C2)-(A2*B2))/D2

Regards

shane

 

[levy77]

Note that the way excel goes about working formulas out, its not completely necessary for all the brackets. Might be handy to understand whats going on but may also add more confusion.