for the tax calculation
=SUMPRODUCT(--(A1{0;17500;40000;75000}),(A1-{0;17500;40000;75000}),
{0.125;0.085;0.12;0.06})
for the net amount =A1-A2
for an explanation of the sumproduct formula see.........
http://www.mcgimpsey.com/excel/variablerate.html
--
Greetings from New Zealand
"Scoober" wrote in message
...
Can someone show me the correct forumla to provide a net mothly figure
e.g
if a gross yearly wage figure is entered into A1 how can i show the tax
paid
in A2 and the resulting nett monthly figure in A3
The formula has to work within the following thresholds:
0-$17,500 taxed at 12.5%
$17,501 - $40,000 taxed at 21%
$40,001 - $75,000.00 taxed at 33%
$75,001 and above taxed at 39%