Logical

XOR function

TRUE if an odd number are TRUE. XOR works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.

Syntax

=XOR(logical1, [logical2, ...])
ArgumentUse
logical1required, repeatable
logical2optional, repeatable
required

On live data

In Sheets, XOR sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.

See the integrations

More logical functions

ANDTRUE if all are TRUEIFConditionalIFERRORFallback if value errorsIFSFirst value whose condition is TRUELETName values for a calculationORTRUE if any is TRUESWITCHResult for the matching valueBYCOLApply a LAMBDA to each columnBYROWApply a LAMBDA to each rowFALSEThe logical value FALSEIFNAFallback if value is #N/AISOMITTEDTRUE if a LAMBDA argument is missing

All 20 logical functions →

Spreadsheet formulas on live business data

Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.

See the integrations