Help needed with 3 formulas

  • Thread starter Thread starter Vidgamer
  • Start date Start date
V

Vidgamer

I have 3 problems, i just want to know how i would go about working al
of this out.

This all relates to a scenario where employees get paid based on ho
well they go, it's to work out how much they get paid etc.. etc...

FIRST PROBLEM:
An employee must PAY 1.5% of their total gross UNLESS they earn ove
$500 and do NOT have health insurance, if this is the case they mus
pay 6% of their total gross.

SECOND PROBLEM / THIRD PROBLEM (figure they can be solved together)
I have a table of tax rates and i need to figure out how excel can rea
off this table and present how much they should be taxed based on thei
gross salary. This problem will also work out how much superannuatio
they should pay but should NOT be done in the same column.

Heres a rough mock up i did:
http://home.iprimus.com.au/vidgamer/untitled.JPG
http://home.iprimus.com.au/vidgamer/untitled2.JPG

cheers in advanc
 
Hi
1. problem:
- C3: gross salary
- D3: Medicare (either 'yes' or 'no' as value)
- Formula to calculate:
=IF(AND(C3<500,D3<>"yes"),C3*0.015,C3*0.06)

2. problem:
- first only enter the lower boundary of the tax bracket
- use VLOOKUP. e.g.
=VLOOKUP(C3,B10:C13,2,1)
 
Back
Top