assay
broadcasting

daa5b2

Subject
IF
Category
value
Formula
=IF({TRUE,FALSE,TRUE}, {10,20,30}, {-1,-2,-3})
Canonical

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets diverge {10, -2, 30}
excel diverge {10, -2, 30}
lattice diverge {10, -2, 30}
ironcalc diverge #N/IMPL!
hyperformula diverge {#NAME?, #NAME?, #NAME?}
libreoffice diverge 10
formulas diverge {10, -2, 30}
pycel diverge 10