| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Nested IF Statements
Hello,
I have a nested IF statement that needs to be much larger than it is. Currently, there are six IF statements all nested into another IF. I need to add eight more IF's into the formula, but Excel won't allow it. Below is the formula. The formula does a HLookup at rangename AccountNumbers. This is the formula as it is currently written: =IF(H13="","",IF(A13="","",HLOOKUP(H13,AccountNumb ers,IF(A13="A",2,IF(A13="B",3,IF(A13="C",4,IF(A13= "D",5,IF(A13="E",6,""))))),FALSE))) Any help anyone can offer would be great! Maybe there is another way of doing this. -- Ken |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF statements | New Users to Excel | |||
| Nested IF statements | Excel Discussion (Misc queries) | |||
| Nested If/Then statements | Excel Worksheet Functions | |||
| what is the max no. of nested Ifs can an If Statements have in EXC | Excel Discussion (Misc queries) | |||
| Do I need nested IF statements? | Excel Worksheet Functions | |||
Threaded Mode
