Formulas > =XOR()
How to Use XOR() in Google Sheets
Description
How To Actually Use XOR() in Sheets
XOR(logical_expression1, [logical_expression2, ...])
Try XOR yourself
In cells A1 and A2, enter two logical values (TRUE or FALSE). In cell B1, use the XOR function to determine if the values in A1 and A2 are different. The result should be TRUE if they are different and FALSE if they are the same.
Hints (3)
-
Remember, XOR returns TRUE when an odd number of its arguments are TRUE.
-
You need to provide the two logical values as arguments to the XOR function.
-
Check the values in A1 and A2 to see if they are different.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
More related tutorials
Transcript-matched member videos for XOR(). Click through to watch.
Learn more about the XOR() formula:
Generate a XOR() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses XOR(). 2 free AI generations, no signup. Members get unlimited use.
Generate a XOR() formula