Formula for several IFs in 1 single line/cell ..??
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 |
Formula for several IFs in 1 single line/cell ..??
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%)))) Note, you wrote: - 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" wrote in message ... 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 |
Formula for several IFs in 1 single line/cell ..??
thanks ..it works !!!!
|
All times are GMT +1. The time now is 06:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com