| 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 |
| 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) | |||
Threaded Mode
