Formualizer Docs
ReferenceFunctionsLogical (Extended) Functions

XOR

XOR: Returns TRUE when an odd number of arguments evaluate to TRUE.

Summary

XOR aggregates all values and checks parity of truthy inputs.

Remarks

  • Booleans and numbers are accepted (0 is FALSE, non-zero is TRUE).
  • Blank values are ignored.
  • Text and other non-coercible values produce #VALUE!.
  • If no coercion error occurs first, encountered formula errors are propagated.

Examples

Odd count of TRUE values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true
Text input triggers VALUE error
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#VALUE!

FAQ

What determines XOR's final result?

XOR returns TRUE when the count of truthy inputs is odd; blanks are ignored.

Runtime metadata

Category

Logical Ext

Signature

XOR(arg1…: Any)

This function accepts a repeating argument pattern (min args: 1).

Arity

min 1, max variadic

Arguments

arg1

Any · Scalar

Caps

PUREREDUCTIONBOOL_ONLY

Source

crates/formualizer-eval/src/builtins/logical_ext.rs

NOT

NOT: Reverses the logical value of its argument.

Lookup Functions

Generated reference pages for Lookup functions.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat determines XOR's final result?Runtime metadata