Nested IF statements

  • Thread starter Thread starter Katherine Mason
  • Start date Start date
K

Katherine Mason

Does anyone out there know if there is a limit to the
number of IF statements one can have in a formula line? I
get an general error at the 9th IF statement (out of 11),
yet if I limit it to ending at the 8th, no error. Trouble
is, I need all 11... any ideas other than manually
changing all cells? Thank you for reading. km
 
The limit should be 7, but you can use workarounds like + but it would be
better to use a lookup or choose function in the formula or a macro.
 
There is a limit, which is seven nested if's. You would probably be able to
use VLOOKUP. Please repost with more specific info...

Thanks,

tim
 
I thought it was 7, guess you got 8.

There would be more suggestions I'm sure, if you told what you were trying
to do. Im sure there is an easier way than 11 if statements.
 
Does anyone out there know if there is a limit to the
number of IF statements one can have in a formula line? I
get an general error at the 9th IF statement (out of 11),
yet if I limit it to ending at the 8th, no error. Trouble
is, I need all 11... any ideas other than manually
changing all cells? Thank you for reading. km
Click to expand...

If you look in HELP for "specification", you will find:

"Nested levels of functions 7"

So you can only nest 7 IF's or any other function. Your results are in accord
with the specifications.

If you post what you are trying to do, someone will be able to give you
guidance, I'm sure.


--ron
 
I thought it was 7, guess you got 8.

There would be more suggestions I'm sure, if you told what you were trying
to do. Im sure there is an easier way than 11 if statements.
Click to expand...

Actually, from what the OP posted, I would say that she "nested" seven. The
outermost IF would not have been "nested".


--ron
 
OK, I now know there is limit of 7. Does anyone know how
I can get around that so I can include all 11?
 
Post what you want the formula to do and you will get a reply. Trying to use
more than 3 IFs, never mind 7, is cumbersome and inefficient and prone to
error. There's always a better way!
 
It would help if you read all the answers you got, post the formula you have
now that won't work
There are several ways of bypassing this but it is helpful to see the
formula
 
Back
Top