lambda

`c2caf0`

Subject: FILTER
Category: value
Formula: =FILTER({1;2;3}, {0;0;0}, "none")
Canonical: none

Owning divergences (2)

DV-0018 lattice: different error code — ADD, AVERAGE, AVERAGE.WEIGHTED (+5 more)
error-code lattice
DV-0023 gsheets: different error code — CONCAT, FILTER, NORM.S.DIST (+1 more)
error-code gsheets

Per-engine results

matches canonical diverges no fixture

Engine	Verdict	Value
gsheets	diverge	#N/A
excel	match	none
lattice	diverge	#VALUE!
ironcalc	diverge	#NAME?
hyperformula	diverge	{#N/A; #N/A; #N/A}
libreoffice	diverge	#NAME?
formulas	match	none
pycel	diverge	#NAME?