View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
René René is offline
external usenet poster
 
Posts: 2
Default 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é