IF and or

[tango]

Dear All,
i wonder if vba supports AND or OR?
i try to use the AND or OR but error

IF sum = 100 then OR
sum = 200 then
..............
ELSE
..............
END IF

thanks

 

[Chip Pearson]

Try something like

If sum = 100 Or sum = 200 Then
' do something
Else
' do something else
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Dave Peterson]

if sum = 100 _
or sum = 200 _
then
'do onething
else
'do another
end if

or maybe:

if sum = 100 then
'do one thing
elseif sum = 200 then
'do a 2nd thing
else
'do a 3rd thing
end if