software

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...?--
Huntamp;amp;Peck
------------------------------------------------------------------------
Huntamp;amp;Peck's Profile: www.excelforum.com/member.php...oamp;userid=32961
View this thread: www.excelforum.com/showthread...hreadid=527873Hi!

= purchase_amount*(1-result_of_Datedif_formula/10)

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

=C1*(1-B1/10)

Biff

lt;Huntamp;ampgt;; quot;Peckquot;
gt; wrote in message
...
gt;
gt; I have a column which includes dates when items were purchased. I have
gt; used the DATEDIF function to find the number of years between that date
gt; and today's date. I now want to decrease the purchase amount 10% for
gt; every year calculated via the DATEDIF function.
gt;
gt; Any ideas, is this possible, why can't I think...?
gt;
gt;
gt; --
gt; Huntamp;amp;Peck
gt; ------------------------------------------------------------------------
gt; Huntamp;amp;Peck's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32961
gt; View this thread: www.excelforum.com/showthread...hreadid=527873
gt;