| 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 |
| 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 | |||
Threaded Mode
