Hi all,

Can someone Please provide me with a formula to calculate take home pay
based on annual salary.

The tax rates are as follows,

Tax on this income

0 - $6,000
Nil tax

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

$37,001 - $80,000
$4,650 plus 30c for each $1 over $37,000

$80,001 - $180,000
$17,550 plus 37c for each $1 over $80,000

$180,001 and over
$54,550 plus 45c for each $1 over $180,000

I want to be able to key a value (Annual Salary) into cell A1 and know how
much tax I will have to allow for OR what the nett salary will be for my
staff.

Your help will be appreciated greatly

Roger