nested if with and and or functions

[jessmtz19]

I have to make a formula using a nested if function to determine the # of
vacation days ea. employee is eligible for based on the employye's job status
in column B and on the #of years employeed in column C.
17days for FT who have worked more than5 years,12days for FT who worked more
than1 year, 7days for FT who have worked 1year or less, 0 for everyone else.
=IF(B6="FT",IF(C6>5,17,IF(C6>1,12,IF(C6<=1,7,0))),"") This is what i came up
but its wrong. then i have toenter a formula using a nested if function with
and and or functions with in it to determine ea. emplyees total family leave
time in column G.5days FT worked 1or more years, 3days FT worked less than
1year or for PT worked more than 2 years,everyone else 0

 

[Jerry W. Lewis]

You say that your formula is wrong, but you don't say what it is doing that
you don't like. The formula is written to give 17 days to FT employees who
have worked more than 5 years, 12 days to FT employees who have worked more
more than one year but less than or equal to 5, 7 days for FT emplyees who
have worked less than or equal to 1 year, and 0 for all other FT employees
(all employement lengths have already been covered, so this branch will never
occur). Employees who are not full time get "".

Perhaps you meant
=IF(B6="FT",IF(C6>5,17,IF(C6>1,12,7)),0)

Jerry