Formualizer Docs
ReferenceFunctionsLogical (Extended) Functions

NOT

NOT: Reverses the logical value of its argument.

Summary

NOT converts the input to a logical value, then flips it.

Remarks

  • Numbers are coerced (0 -> TRUE after inversion, non-zero -> FALSE after inversion).
  • Blank values are treated as FALSE, so NOT(blank) returns TRUE.
  • Text and other non-coercible values return #VALUE!.
  • Errors are propagated unchanged.

Examples

Invert boolean
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
false
Invert numeric truthiness
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true

FAQ

How does NOT treat blanks?

Blank is treated as FALSE first, so NOT(blank) returns TRUE.

Runtime metadata

Category

Logical Ext

Signature

NOT(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

IFS

IFS: Returns the value for the first TRUE condition in condition-value pairs.

XOR

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

On this page

SummaryRemarksExamplesRelated functionsFAQHow does NOT treat blanks?Runtime metadata