| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested "IF" With "And"and "OR" functions
In Excel 2003, I can't figure out the fomula for a company that has full time
and part time employees who recieve family leave time. For full time employees who have been employed 1 year or more they get 5 days, if they have been employed less than 1 year they get 3 days. For part time employees who have been employed 2 or more years they get 3 days. This needs to be formulated in 1 cell. Can anybody help me, I'm going crazy with all the errors in my Syntax. -- Frustrated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating Nested Functions | Excel Worksheet Functions | |||
| More than 7 nested "IF" functions? | Excel Worksheet Functions | |||
| Is there any way around the maximum of seven nested functions? | Excel Worksheet Functions | |||
| INFORMATION ON FUNCTIONS IN EXCEL (EX. "IF", VALUE LOOKUP) | Excel Worksheet Functions | |||
| ENTER EXCEL FORMULA WITH MORE THAN 7 NESTED FUNCTIONS | Excel Worksheet Functions | |||
Threaded Mode
