Forum Discussion
Formula to reduce a number by 10% each day
I am looking for a formula that will reduce an amount by 10% each day. Example: Day 1 - $60,000*10%=$6,000. $60,000 - $6,000= $54,000. Day 2 - $54,000*10%= $5,400. $54,000 - $5,400= $48,600. I a...
How do I get this to calculate in one cell? Use an IF formula?
You'd need VBA code for that, but I wouldn't recommend it.
It's easier to create a list with dates and the corresponding amounts: