I need a spreadsheet to depreciate several items of differing ages. For
example, Items placed in service in 2004, 2005, and 2006 with the total
valuation depreciated by year. Equipment investments are made each of those
years, say $2mm, $4mm, and $1mm, are made in each of those years. In year 1
(2004), the $2mm valuation is taxed at 92%; in year two, the $4mm in new
investment is taxed at 92% but the Year one investment is taxed at 85%; In
year three, the figure is 79%. I'm trying to sum all of these figures.

I think this is what you want. assumes date in column A and value in
column B. Copy & paste from below into the formula bar.

=IF(YEAR(A2)-2004=0,B2*92%,0)+IF(YEAR(A2)-2004=1,B2*85%,0)+IF(YEAR(A2)-2004=2,B2*79%,0)


--
BrianB


------------------------------------------------------------------------
BrianB's Profile: http://www.excelforum.com/member.php...info&userid=55
View this thread: http://www.excelforum.com/showthread...hreadid=274018