I need help nesting an IF function inside another IF function. Say I have four columns. Name(John), Status(FT), Yrs Employed(3), and Vacation Leave(?).
Vacation Leave is based on the status, only FT employees qualify and the number of Years employed.
17 days for full-time employees who have worked more than 5 years.
12 days for FT employees who have worked more than 1 year, 7 days for FT employees who have worked for less than 1 year. 0 for everyone else. Somebody help me please.