Help please - formula to calculate Tax
 

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

Help please - formula to calculate Tax
 

On Sunday, April 22, 2012 5:11:19 AM UTC-5, Roger Dodger wrote:
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

http://networkfp.com/file/download-i...12-13-in-excel

Help please - formula to calculate Tax
 

On Sun, 22 Apr 2012 20:11:19 +1000, Roger Dodger wrote:

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
....
$6,001 - $37,000
15c for each $1 over $6,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.

Use VLOOKUP.


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...

Help please - formula to calculate Tax
 

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

Help please - formula to calculate Tax
 

OOPS..
There's a mistake in the second formula.(A3+) change the + for - as per sample
below.
=A3-IF(A3<$G$1,0,IF(A3<$H$1,(A3-6000)*$H$2,IF(A3<$I$1,(A3-37000)*$I$2+4650,IF(A3<$J$1,(A3-80000)*$J$2+17550,IF(A3$K$1,(A3-180000)*$K$2+54550)))))
"Cimjet" wrote in message
...
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