Hi Roger
See link attached. It's a sample file make sure its what you want.
http://cjoint.com/?BDxbj5jlxxW
Cimjet
"Roger Dodger" wrote in message
ond.com...
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