Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() -- Could you please help me with this formula. I am trying to use a nested IF and AND formula to calculate the vaction days for full time employess with different service years. I need to nest 3 different answers. Here is my formula that keeps getting rejected: =IF(And([Status]="FT",[Years Employed]=4,15,IF([Years Employed]=24,10,IF([Years Employed]=1<2,5,0))). What am I not doing right?? -- kae |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Regarding NESTED IF formula | Excel Discussion (Misc queries) | |||
Help with formula €“ too many nested IFs | Excel Worksheet Functions | |||
Nested Formula help | Excel Worksheet Functions | |||
Nested Formula | Excel Worksheet Functions | |||
Nested Formula | Excel Worksheet Functions |