What do the logical operators AND, OR, XOR and NOT do?

  • Google+ icon
  • LinkedIn icon
  • 752 views

AND (both conditions on either side of the AND operation MUST be satisfied for the IF function to work)

OR (either condition on each side of the OR operation MUST be satisfied for the IF function to work)

NOT (used when something needs to be displayed UNLESS a value is a certain amount/type/name etc.)

XOR (used when exclusively ONE of the conditions has to be met – not both! This is where XOR and OR differ.)

Chris D. A Level Computing tutor, A Level Maths tutor, GCSE Maths tut...

About the author

is an online A Level Computing tutor with MyTutor studying at Bath University

Still stuck? Get one-to-one help from a personally interviewed subject specialist.

95% of our customers rate us

Browse tutors

We use cookies to improve your site experience. By continuing to use this website, we'll assume that you're OK with this. Dismiss

mtw:mercury1:status:ok