Google Sheets
XOR function in Google Sheets
The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise. .
=XOR(logical_expression1, [logical_expression2, ...])XOR syntax and parameters
Two arguments, one required.
- logical_expression1booleanRequired
- logical_expression2booleanRepeating
XOR examples
Formulas you'll actually reuse.
TRUE when exactly one of two checks passes — not both, not neither:
=XOR(B2 = C2, D2 = E2)Result
TRUEExactly one of two sign-off columns should say Yes:
=IF(XOR(F2 = "Yes", G2 = "Yes"), "One approver", "Check")Result
"One approver"
XOR in Excel
Same name — your formula ports as-is.
Try XOR in the playground
Edit the example — nothing to install.
Preloaded with the XOR formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ANDReturns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.LogicalExcel
- FALSEReturns the logical value `FALSE`.LogicalExcel
- IFReturns one value if a logical expression is `TRUE` and another if it is `FALSE`.LogicalExcel
- IFERRORReturns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.LogicalExcel
- IFNAEvaluates a value. If the value is an #N/A error, returns the specified value. .LogicalExcel
- IFSEvaluates multiple conditions and returns a value that corresponds to the first true condition.LogicalExcel