Formula for several IFs in 1 single line/cell ..??

[Mayte]

anybody knows how to do a formula in one single line (cell) for the
following? ..please????

I need to calculate tax percentage based on the following (all in one big
formula):

- if home has 1 bedroom = tax is 0.75%
- if home has 2 bedrooms = tax is 1%
- if home has 3 or more bedrooms AND home is less tan 10 years = tax is 1.25%
- if home has 3 or more bedrooms AND home is less tan 20 years BUT more
than 9 years = tax is 1.25%
- if home has 3 or more bedrooms AND home is more than 20 years = tax is
1.75%

anyhelp will be very very appreciate it !!

Cheers,
Mayte

 

[JoeU2004]

Suppose A1 is the number of bedrooms (I assume >=1) and A2 is the age of the
home. Then the tax rate is:

if(A1=1, 0.75%, if(A1=2, 1%, if(A2<10, 1.25%, if(A2<20, 1.50%, 1.75%))))

- if home has 3 or more bedrooms AND home is less tan 10 years = tax is
1.25%
- if home has 3 or more bedrooms AND home is less tan 20 years BUT more
than 9 years = tax is 1.25%

I assume you meant a different tax rate for the 9-to-20-year age. I used
1.50%.


----- original message -----

 

[Mayte]

thanks ..it works !!!!