OR in IF
Thanks David. The question came up under Worksheet Functions on the Microsoft
Forum and I did not read it properly and missed the VBA at the end of the
question and thought that a worksheet function was required.
--
Regards,
OssieMac
"David Biddulph" wrote:
Are you sure that's VBA?
--
David Biddulph
"OssieMac" wrote in message
...
The or is a function like this with each condition separated by a comma:-
=IF(OR(A4=1,B4=2,C4=3),"Yes","No")
--
Regards,
OssieMac
"T2net" wrote:
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
|