| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Wild Characters in "IF" function | Excel Discussion (Misc queries) | |||
| Date & Time | New Users to Excel | |||
Hybrid Mode
