assay

DV-0055

lattice: different error code — AVERAGE, SUM

Cause
error-code
Category
error-code
Diverging engines
lattice
Behavior signature
{"error":"#DIV/0!"}
Test count
2
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (2)

AVERAGE SUM

Tests (2)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
SUM/nested-error-priority =SUM(#N/A, 1/0) #N/A gsheets#N/A excel#N/A lattice#N/A ironcalc#N/A hyperformula#N/A libreoffice— formulas#N/A pycel#NAME?
AVERAGE/average-with-booleans =AVERAGE(TRUE, FALSE, TRUE) 0.666667 gsheets0.666667 excel0.666667 lattice#DIV/0! ironcalc0.666666667 hyperformula#NAME? libreoffice— formulas0.666667 pycel#DIV/0!