`if-false-branch`

Subject: IF
Category: value
Formula: =IF(FALSE, 1, 2)
Canonical: 2

Owning divergences (1)

DV-0006 hyperformula: function not implemented — AND, AVERAGE, AVERAGEIFS (+19 more)
missing-function hyperformula

Per-engine results

matches canonical diverges no fixture

Engine	Verdict	Value
gsheets	match	2
excel	match	2
lattice	match	2
ironcalc	match	2
hyperformula	diverge	#NAME?
libreoffice	diverge	—
formulas	match	2
pycel	match	2