M

#### Mark McDonough

Aim: to select from a drop down box one's salary range and then spit out the

marginal tax rate. The rates are as follows:

Australian 2006/2007 Income Tax Rates

$0 - $6,000 Nil

$6,001 - $25,000 15c for each $1 over $6,000

$25,001 - $75,000 $2,850 plus 30c for each $1 over $25,000

$75,001 - $150,000 $17,850 plus 40c for each $1 over $75,000

Over $150,000 $47,850 plus 45c for each $1 over $150,000

Cell B183 is where the user selects their salary range from a drop down box.

The formula I have used (which doesn't work) is given below:

=IF(B183="$0 - $6,000","Nil",

IF(B183="$6,001 - $25,000",15%,

IF(B183="$25,001 - $75,000",30%,

IF(B183="$75,001 - $150,000",40%,

IF(B183="Over $150,000",45%,0)))))

where am I going wrong in this type of formula as I've done a few of them

now and without success.

I also would like a formula such that one types in their salary (actual

dollars - not a range) and the formula is to arrive at the amount of tax due

on a given salary.