| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Nested IF and AND formula
Thank you so much. My formula now works.
-- kae "Billy Liddel" wrote: Carrie Try =IF(AND(A16="FT",B16<=2),5,IF(AND(A16="FT",B16<=4) ,10,IF(AND(A16="FT",B164),15,0))) where A16 is status and B16 is the years employed. Regards Peter "carrie08" wrote: -- 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
