| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
long IF statement with lots of OR's
Hi
Is there a smarter way to write this kind of code ? If InputParameter1 = "A" And (InputParameter2 = "X" Or InputParameter2 = "Y" Or InputParameter2 = "Z" and so on) Then [...] My intuition would go for something like this: If InputParameter1 = "A" And InputParameter2 In ("X", "Y", "Z", and so on) but that doesn't seem to be correct. Any ideas ? René |
| 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) | |||
Threaded Mode
