K
Ken
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,AccountNumbers,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.
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,AccountNumbers,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.