# if >10 add to amount, if not use prefious amount.

0

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

### Discussion

There are 8 million different ways to do this. Please include a sample spreadsheet in your question - upload it, don't just copy/paste data from cells. The formula is specific to the setup in your spreadsheet.
don (rep: 1382) Aug 9, '16 at 10:36 pm
ok i added the sheet.
Yoeri90 Aug 10, '16 at 4:25 am
There is potentially a very complex formula that could be used to do this but it would not work very well and would be veryyyy easy to break on accident. I think you should use another program to do this or use some other kind of template for your data so that it is easier to manage.
don (rep: 1382) Aug 11, '16 at 11:24 am

0

Please check the file in attach.

Each time you put the "X" on column J the system will calculate the interest on the next line.

Enjoy it!

0

tray this file