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




"tango" wrote in message
om...
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