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
