Using Or and And Operators

  • Thread starter Thread starter RyanH
  • Start date Start date
R

RyanH

Can someone tell me why If statement below equates to True? I really need to
know how the computer reads this expression. I thought the computer reads it
from left to right, like this:

True Or False = TRUE
Then
TRUE And False = False

but, the computer says I'm wrong, why? How should I read this If Statement?

If True Or False And False Then
msgbox "Do Something"
End If
 
It is always best to use parethesis to make sure calcuations are done in the
order you want. See VBA Help under PRECEDENCE for full explaination.
Basically the AND is done before the OR so you have

True Or (False And False)
True or False
True
 
Thats what I needed. Thanks!
--
Cheers,
Ryan


Joel said:
It is always best to use parethesis to make sure calcuations are done in the
order you want. See VBA Help under PRECEDENCE for full explaination.
Basically the AND is done before the OR so you have

True Or (False And False)
True or False
True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top