S
Suzie
Hi
I am doing an assessment for TAFE and need some help doing a formula, so if
there is anybody out there willing to help, I would really appreciate it.
Using lookups, vlookups of If's - we need to work out the tax payable on the
gross wage. Currently my gross wages are in Column H starting at Row 5.
Below is the tax table we have to use. I can do the first part using a
lookup fine, but just cannot seem to add the second part in about the 30
cents so that it work. Any help gratefully accepted.
Suzie
Taxation Rates for Payroll
if weekly pay is then
between and deduct
up to $95 $0.00
$96 $345 $46.00
$346 $480 $63.00
$481 $672 $96.00
$673 $961 $183.00
$962 or over $308.00
In addition, if an employee's gross wage is over
$480 per week, then they must pay an additional
30 cents in the dollar for every dollar over $480.
I am doing an assessment for TAFE and need some help doing a formula, so if
there is anybody out there willing to help, I would really appreciate it.
Using lookups, vlookups of If's - we need to work out the tax payable on the
gross wage. Currently my gross wages are in Column H starting at Row 5.
Below is the tax table we have to use. I can do the first part using a
lookup fine, but just cannot seem to add the second part in about the 30
cents so that it work. Any help gratefully accepted.
Suzie
Taxation Rates for Payroll
if weekly pay is then
between and deduct
up to $95 $0.00
$96 $345 $46.00
$346 $480 $63.00
$481 $672 $96.00
$673 $961 $183.00
$962 or over $308.00
In addition, if an employee's gross wage is over
$480 per week, then they must pay an additional
30 cents in the dollar for every dollar over $480.