MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I need help on a formula


Posted by Brian on October 04, 2000 12:08 PM

I am trying to determine depreciation of assets. The
Iwas given this to work with: The range will contain
a value from 1-7. Here are the rates of depreciaiton:

1-3 years old 40% of cost
4-6 years old 20% of cost
over 7 years old 10%

I understand the formula I need to use but I can't figuer
out how to imbed all these into one formula. HELP!


Posted by Neil on October 04, 2000 12:38 PM

If A1 is the cost and B1 is the given value

=IF(B1<=3,A1*0.4,IF(AND B1>=3,B1<7),A1*0.2,B1*0.1))

You could also use put the values and rates in a table and use VLOOKUP

Posted by I needhelp on a formula also on October 08, 2000 6:47 PM