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

Answer
Discuss

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: 1247) 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: 1247) Aug 11, '16 at 11:24 am
Add to Discussion

Answers

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!

Discuss
0

tray this file

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login