Thread: OR in IF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Hodge[_2_] Nick Hodge[_2_] is offline
external usenet poster
 
Posts: 185
Default OR in IF

T2Net

=IF(OR(Condition1,Condition2,Condition3....),DoThi s,ElseDoThis)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.excelusergroup.org
web: www.nickhodge.co.uk





"T2net" wrote in message
...
Do you know a way to include several conditions to one IFstep in VBA,
ie

If condition1 OR condition2 OR condition3 then action1
without using my current unelegant and heavy:

If condition1 then action1
If condition 2 then action1
If condition 3 then action1


I am sure the trick is easy..so easy that I cannot find it!

Thanks in advance for your help,

T2net