Applying Percent Decrease Across Set Periods

  • Thread starter Thread starter Hunt&Peck
  • Start date Start date
H

Hunt&Peck

I have a column which includes dates when items were purchased. I have
used the DATEDIF function to find the number of years between that date
and today's date. I now want to decrease the purchase amount 10% for
every year calculated via the DATEDIF function.

Any ideas, is this possible, why can't I think...?
 
Hi!

= purchase_amount*(1-result_of_Datedif_formula/10)

A1 = some date
B1 = Datedif formula
C1 = purchase amount

=C1*(1-B1/10)

Biff

<Hunt&amp>; "Peck"
 
Back
Top