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

[Richard Freist]

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?
--
Frustrated

[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)

"Richard Freist" <Richar...@discussions.microsoft.com> wrote in message
news:46FD1E9F-B756-46B8...@microsoft.com...

[Gary''s Student]

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
--
Gary's Student
gsnu200703

[Earl Kiosterud]

Gary's Student,

Yeah. Now if we only had a BUT() function.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Gary''s Student" <GarysS...@discussions.microsoft.com> wrote in message
news:00659E75-C65E-4F1C...@microsoft.com...

[Bob Phillips]

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

"Gary''s Student" <GarysS...@discussions.microsoft.com> wrote in message
news:00659E75-C65E-4F1C...@microsoft.com...