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



tango wrote:

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

--

Dave Peterson