Function =IF statment limits

S

SeeStation

=IF(C233=Sheet1!D17,Sheet1!C17,IF(C233=Sheet1!D18,Sheet1!C18,IF(C233=Sheet1!D19,Sheet1!C19,IF(C233=Sheet1!D20,Sheet1!C20,IF(C233=Sheet1!D22,Sheet1!C22,IF(C233=Sheet1!d23,Sheet1!C23,IF(C233=Sheet1!D26,Sheet1!C26,IF(C233=Sheet1!D27,Sheet1!C27,IF(C233="Choose Card Set","Choose Card Set","Not Available"))))))))))

Gives an error - only thing I can think of is it is too long?
Any suggestions? If it is too long is there another way to make this work?
You guys are great! Thanks in advance.
 
S

Sunny FL

It may be the length, I have broken up statements like this into 2 cells. Go
about half way and then in the last "else" statement, point to the next cell
and finish the "if" statment.
 
S

SeeStation

Never thought about doing that. Great idea and it works perfectly. If
someone takes a look at this if you want to hide the results of the cell with
the function extension, make the text the same color as the background. No
one will know it's there.
 
S

ShaneDevenshire

Hi,

Excel <=2003 allows a maximum of 7 levels of nesting. Alternatives:
1. Upgrade to 2007 for 64 levels deep
2. Switch from this multiple IF to a VLOOKUP.
3. Create the deep nesting in Lotus 1-2-3 or Quattro Pro and save it as an
Excel file and open it in Excel.
 
Top