| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF not working.....
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
