Formualizer Docs
ReferenceFunctionsLogical Functions

AND

AND: Returns TRUE only when all supplied values evaluate to TRUE.

Summary

AND evaluates arguments left to right and short-circuits on a decisive FALSE.

Remarks

  • Booleans and numbers are accepted (0 is FALSE, non-zero is TRUE).
  • Blank values are treated as FALSE.
  • Text and other non-coercible values yield #VALUE! unless a prior FALSE short-circuits.
  • If no decisive FALSE is found, the first encountered error is returned.

Examples

All truthy inputs
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true
Text input causes VALUE error
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#VALUE!

FAQ

What happens with blanks and text in AND?

Blank values evaluate as FALSE; non-coercible text yields #VALUE! unless a prior FALSE short-circuits.

Runtime metadata

Category

Logical

Signature

AND(arg1…: Any)

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

Arity

min 1, max variadic

Arguments

arg1

Any · Scalar

Caps

PUREREDUCTIONBOOL_ONLYSHORT_CIRCUIT

Source

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

Logical Functions

Generated reference pages for Logical functions.

FALSE

Returns the logical constant FALSE.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat happens with blanks and text in AND?Runtime metadata