Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for several IFs in 1 single line/cell ..??
thanks ..it works !!!!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average line needed from one single cell | Charts and Charting in Excel | |||
How do I use a single cell value to chart a horizontal line in Exc | Charts and Charting in Excel | |||
Concatenate: Multi-Line Cell with 2 single line cells | Excel Worksheet Functions | |||
More than one line in a single cell? | New Users to Excel | |||
Is it possible to do it by a single-line formula(without using VBA)? | Excel Discussion (Misc queries) |