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)))