View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Hunt&Peck
 
Posts: n/a
Default 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