Nesting If Functions

[nelsonjos]

Hello,

I am working on creating a payroll. I am attempting to add a line to how much medical insurance will be taken out each paycheck. The parameters that I need to follow are: $30 automatically is taken out, with dependents more than 2 but less than 3 pay additional 6.50/dependent over 2, dependents over 2 but less than 6 pay additional 5.50/dependent, and over 6 dependents pay the rate for 6 dependents.

I have been working on this for hours and the formula that I have right now is:
If(MedicalInsurance="NO",0,If(dependents>6,($5.50*6)+$30,If(dependents>3,(dependents*$5.50)+$30,if(dependents<3,(dependents*$6.50)+$30,0))))

I have a feeling that I am making one little mistake but cannot figure it out.

Any help is much appreciated.

 

[kevatarvind]

remove all $ Sign in formulas and use it in Cell Formats

 

[nelsonjos]

Most of those are just there to explain what I am trying to do. I have most of those numbers on a different sheet, I just didn't want to make it more confusing than it already is.