| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
long IF statement with lots of OR's
You could put your parameters in a certain cell and reference that, as
you suggested. For instance: =IF(AND(A1="xyz", ISERROR(FIND(<the reference to your input parameter, <the reference to your list of acceptable values))=FALSE)=TRUE, 1, 0) Please let me know if that doesn't work. Mark --- Mark Bigelow mjbigelow at hotmail dot com http://hm.imperialoiltx.com *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Long If Statement | Excel Worksheet Functions | |||
| Excel cut and paste row takes a long time. Lots of formulas. | Excel Discussion (Misc queries) | |||
| very long statement | Excel Discussion (Misc queries) | |||
| IF statement too long | Excel Discussion (Misc queries) | |||
| Long IF Statement | Excel Discussion (Misc queries) | |||
Hybrid Mode
