Formualizer Docs
ReferenceFunctionsInformation Functions

ISLOGICAL

ISLOGICAL: Returns TRUE when the value is a boolean.

Summary

Returns TRUE when the value is a boolean.

Remarks

  • Only logical TRUE/FALSE values return TRUE.
  • Numeric truthy/falsy values are not considered logical by this predicate.
  • Errors return FALSE.

Examples

Boolean input
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true
Numeric input
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
false

FAQ

Do truthy numbers count as logical values?

No. ISLOGICAL returns TRUE only for actual boolean TRUE/FALSE values.

Runtime metadata

Category

Information

Signature

ISLOGICAL(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

ISFORMULA

ISFORMULA: Returns whether a value originates from a formula.

ISNA

ISNA: Returns TRUE only for the `#N/A` error.

On this page

SummaryRemarksExamplesRelated functionsFAQDo truthy numbers count as logical values?Runtime metadata