=IF function - Need more than 7 nested stmts.

  • Thread starter Thread starter David
  • Start date Start date
D

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
 
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.
 
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.
 
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","")
 
Back
Top