Help needed with 3 formulas

[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

 

[Frank Kabel]

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)