Increase Average By 1

[deemer98]

A1 is 7428
B1 is 39
D1 is A1/B1

I want C4 to display the result required to increase D1 by 1. However, the B column will increase by 3 each time. So this time it will be 42 instead of 39.

I’m trying, but not succeeding! Thanks!

 

[deemer98]

If my request is confusing, think of it like bowling. If my total pinfall is currently 7428 for 39 games, I have an average of 190.4615. What will my 3 game total score need to be after 42 total to increase my average by 1 point?

 

[Fluff]

One way

+Fluff 1.xlsm
	B		D
1	7428		8041.385
2	39
3	190.4615
Lists

Cell Formulas
Range	Formula
D1	D1	=((B3+1)*B2)+(B3+1)*3
B3	B3	=B1/B2

 

[deemer98]

Thank you Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.