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...
Yes, I fixed my calculation. I need this calculated in one cell. Basically, it is a 10% reduction for every day late a vendor submits a report. Would I use an IF formula for that?
You can have a differente approach.
You can stablish a starting date and make a calculation with the difference between actual date and the starting date.
Lets say
A2=starting date
B2= Amount
C2=B2*(1-(0,1*(TODAY()-A2)))
You can stablish a starting date and make a calculation with the difference between actual date and the starting date.
Lets say
A2=starting date
B2= Amount
C2=B2*(1-(0,1*(TODAY()-A2)))
I like that idea, but the formula in C2 should be
=B2*90%^(TODAY()-A2)
(Each day, we want to subtract 10% of the amount of the previous day, not of the starting amount)
- Yep. Thank you
