i want a cell where people can fill in their start amount. (any amount)
for this example i will use $100.
every day we get 4% interest. which we may deposit if its above $10.
basicly in this example we need 3 days to make our first deposit.
in the sheet it deposits every day because i dont know how to do the formula.
day 2 and day 3 should still be $100 because $4 + $4 = <$10
day 4 we have $4 + $4 + $4 = >$10 ( now $12 should be added to the $100 )
and so on.
i added my sheet down here to make it easyer to understand.
Startamount: $100,00 Day 1 $100,00 $4,00 Day 2 $100,00 $4,00 Day 3 $100,00 $4,00 Day 4 $112,00 $4,48 Day 5 $112,00 $4,48 Day 6 $112,00 $4,48 Day 7 $125,44 $5,02 Day 8 $125,44 $5,02 Day 9 $135,48 $5,42 Day 10 $135,48 $5,42