| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Function =IF statment limits
=IF(C233=Sheet1!D17,Sheet1!C17,IF(C233=Sheet1!D18, Sheet1!C18,IF(C233=Sheet1!D19,Sheet1!C19,IF(C233=S heet1!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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Function =IF statment limits
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. -- Sunny FL "SeeStation" wrote: =IF(C233=Sheet1!D17,Sheet1!C17,IF(C233=Sheet1!D18, Sheet1!C18,IF(C233=Sheet1!D19,Sheet1!C19,IF(C233=S heet1!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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Function =IF statment limits
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. "Sunny FL" wrote: 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. -- Sunny FL "SeeStation" wrote: =IF(C233=Sheet1!D17,Sheet1!C17,IF(C233=Sheet1!D18, Sheet1!C18,IF(C233=Sheet1!D19,Sheet1!C19,IF(C233=S heet1!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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Function =IF statment limits
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. -- Thanks, Shane Devenshire "SeeStation" wrote: =IF(C233=Sheet1!D17,Sheet1!C17,IF(C233=Sheet1!D18, Sheet1!C18,IF(C233=Sheet1!D19,Sheet1!C19,IF(C233=S heet1!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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum function limits | Excel Discussion (Misc queries) | |||
| limits on lookup function? | Excel Worksheet Functions | |||
| Limits of MINV matrix function | Excel Worksheet Functions | |||
| IF statment/function | Excel Discussion (Misc queries) | |||
| How do i set up if function with more than level limits? | Excel Worksheet Functions | |||
Hybrid Mode
