=IF function - Need more than 7 nested stmts.

[David]

I am looking for a way to get around the limit to only 7
nested if statements in one formula. Is there any way to
incorporate "OR", or is there another way to expand?

Thanks,

David

 

[J.E. McGimpsey]

Functions can only be nested to 7 levels. There's a workaround here:

http://cpearson.com/excel/nested.htm

OTOH, in my experience, I've never found a situation where nesting
more than about 4 or 5 if's wasn't better handled another way -
either using mathematical relationships or using lookup tables.

 

[Vasant Nanavati]

Hi David:

Did you not see my response to your previous post?

Regards,

Vasant.

 

[Don Guillett]

lookup functions or choose function, etc

 

[Zobieda]

Did you ever get your question answered? What did you do,
if so? I'm trying to complete the following formula but
coming across the same problem. =IF(B5=Data!B2,"x",IF
(B5=Data!B3,"x"......etc. It keeps giving me an error at
data!B9...I need to go to Data!B20. Let me know if you
solved your problem and what you did.

 

[J.E. McGimpsey]

You can see if there were any answers in the Google archives (it may
take a few hours for them to show up):

http://google.com/advanced_group_search?q=group:*excel*

Put the subject in the Subject box, or the author's name or email
address in the Author box and limit the dates for best results.

In your case, it seems to me the best alternative is

=IF(COUNTIF(Data!B3:B20,B5),"x","")