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

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

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

=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" wrote in message
...
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

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

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


"Richard Freist" wrote:

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

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

Gary's Student,

Yeah. Now if we only had a BUT() function.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Gary''s Student" wrote in message
...
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


"Richard Freist" wrote:

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

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

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



"Gary''s Student" wrote in message
...
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


"Richard Freist" wrote:

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