81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise..

How To Use in Sheets

XOR(logical_expression1, [logical_expression2, ...])

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.