View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mayte Mayte is offline
external usenet poster
 
Posts: 64
Default 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