How do I set this up?

A

Arpusslim

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

BrianB

I think this is what you want. assumes date in column A and value i
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to pick a value out of a table 2
Help! How do I return the latest of a series of dates using Vlooku 4
SUMIF and AND function 3
Can the linking ever end? 3
How do I get an anniversary date? 1
How do I create a filter to return counts 1
How do I set up multiple logical conditions on one result cell 1
How do I set up Outlook to remind me of birthdays and give age 3

Top