| 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. |
| 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 | |||
Threaded Mode
