Using "IF" with "AND"and "OR" function

[Guest]

A company has both full time and part time employees and fulltime employees
recieve 5 days family leave if they have been employed for 1 year or more,
oterwise they get 3 days. Part time employees recieve 3 days if employed 2
years or more. How can I construct a single formula incorporating both full
time and part time employees?

 

[Bob Phillips]

=IF(status="Full Time",IF(years_employed>=1,5,3),IF(years_employed>=2,3,0))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

If A1 has either ft or pt and B1 has employment years, then:

=(A1="ft")*((B1>=1)*5 + (B1<1)*3)+(A1="pt")*(B1>=2)*3
notice that no
IFs
ANDs
ORs
were necessary

 

[Earl Kiosterud]

Gary's Student,

Yeah. Now if we only had a BUT() function.

 

[Bob Phillips]

But for a guy who asked for a solution to a simpe problem, this provides an
overly complex answer.