Applying Percent Decrease Across Set Periods
 

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...?


--
Hunt&Peck
------------------------------------------------------------------------
Hunt&Peck's Profile: http://www.excelforum.com/member.php...o&userid=32961
View this thread: http://www.excelforum.com/showthread...hreadid=527873

Applying Percent Decrease Across Set Periods
 

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"
wrote in message
...

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...?


--
Hunt&amp;Peck
------------------------------------------------------------------------
Hunt&amp;Peck's Profile:
http://www.excelforum.com/member.php...o&userid=32961
View this thread: http://www.excelforum.com/showthread...hreadid=527873