assay
financial-timevalue

xnpv-mismatched-lengths

Subject
XNPV
Category
value
Formula
=XNPV(0.1, A1:A3, B1:B2)
Canonical
#NUM!

Owning divergences (3)

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match [object Object]
excel match [object Object]
lattice match #NUM!
ironcalc match #NUM!
hyperformula diverge #VALUE!
libreoffice diverge
formulas diverge -545.573
pycel diverge #NAME?