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...
Let's say the initial amount is in A2.
In A3, enter the formula =90%*A2
Fill or copy down from A3.
Or if you prefer the values in a row, enter the formula =90%*A2 in B2, then fill or copy to the right from B2.
- 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:
