Formualizer Docs
ReferenceFunctionsLogical (Extended) Functions

IFS

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

Summary

IFS(cond1, value1, cond2, value2, ...) evaluates left to right and short-circuits.

Remarks

  • Arguments must be provided as pairs; odd argument counts return #VALUE!.
  • Conditions accept booleans and numbers (0 FALSE, non-zero TRUE); blank is FALSE.
  • Text conditions return #VALUE!; error conditions propagate.
  • If no condition is TRUE, returns #N/A.

Examples

First matching condition wins
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
b
No conditions matched
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#N/A

FAQ

What errors can IFS return on structure issues?

Odd argument counts return #VALUE!, and no TRUE condition returns #N/A.

Runtime metadata

Category

Logical Ext

Signature

IFS(arg1, arg2, ... argN: Any)

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

Arity

min 2, max variadic

Arguments

arg1

Any · Scalar

Caps

PURESHORT_CIRCUIT

Source

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

IFNA

IFNA: Returns a fallback only when the first expression is `#N/A`.

NOT

NOT: Reverses the logical value of its argument.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat errors can IFS return on structure issues?Runtime metadata