assay
financial-timevalue

xirr-with-guess

Subject
XIRR
Category
value
Formula
=XIRR(A1:A3, B1:B3, 0.1)
Canonical

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets diverge 0.0638232
excel diverge 0.0638232
lattice diverge 0.0638232
ironcalc diverge 0.06382317
hyperformula diverge #NAME?
libreoffice match
formulas diverge 0.0638232
pycel diverge #NAME?