Average Balance Goal

[Manolocarzo]

Hi,

I need a formula for how much do I need to imput into my account to reach a minimum monthly balance.

Example:


day 1 100
day 2 200
day 3 200
day 4 220


Monthly Avg. Needed: 400

Therefore I need a formula that tells me how much do I need to imput to my account to reach that 400 average and the next day that number will move and so on.

help me pls

[Richard Buttrey]

Assuming the values are B1:B25 then

Please Login or Register  to view this content.

adjust the row 25 as necessary