assay
type-coercion

3e62ee

Subject
AVERAGE
Category
value
Formula
=AVERAGE(TRUE, FALSE, TRUE)
Canonical
0.666667

Owning divergences (2)

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match 0.666667
excel match 0.666667
lattice diverge #DIV/0!
ironcalc match 0.666666667
hyperformula diverge #NAME?
libreoffice no-data
formulas no-data
pycel no-data