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.
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.