Applying Percent Decrease Across Set Periods

[Hunt&Peck]

I have a spreadsheet indicating when an item was purchased and the cost of that item. These items could have been purchased anywhere from 1999 to today. I have used the DATEDIF function to find the number of years between that date and today's date.

I now want to know how much the item is worth today if it had been depreciated by 10% every year.

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

[Biff]

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"
<[email protected]> wrote in message
news:[email protected]...
>
> 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
>