| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF not working.....
you're welcome.
"Patrick" wrote: That worked perfect. Thanks so much. I knew I was close. "JMB" wrote: When K2 has any value in the first part of the formula other than 71876, it returns "ADJ" for me. you'll need to use OR for your conditional tests. OR(K2={71876,147825,186110,73859,1183639,163773,14 0408,226473}) "Patrick" wrote: Here is the formula that I'm using: =IF(K2={71876,147825,186110,73859,1183639,163773,1 40408,226473},"GSA",IF(K2={235842,245561,235823,23 5843,245337,239135,200830},"CNB",IF(K2={683983,245 144,29839,4813,67555,175821,82901,175645,139429,17 5397,131445,979352,113854,972262,174756,218880,335 8},"CB","ADJ"))) When K2 has any of the values listed in the first part of the IF it returns GSA, like it's supposed to. BUT....if any of the other values listed in the subsequent parts are in K2 it always list ADJ, like it's not in any of the other list. I can't get it to return CNB or CB. Any ideas why? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF Function not working | Excel Worksheet Functions | |||
| Outlining in nested subtotals not working | Excel Worksheet Functions | |||
| Countif with nested function not working? | Excel Worksheet Functions | |||
| COMPARING DATES with nested IF not working- Syntax is correct though | Excel Discussion (Misc queries) | |||
| Nested IF(AND is not working | Excel Worksheet Functions | |||
Threaded Mode
