DV-0045

formulas: different error code — IMDIV, IPMT, PPMT

Cause
error-code
Category
value
Diverging engines
formulas
Behavior signature
{"error":"#NUM!"}
Test count
3
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (3)

IMDIV IPMT PPMT

Tests (3)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
engineering/ba4c58 =IMDIV("6+8i", "2") 3+4i gsheets3+4i excel3+4i lattice{__typeof: "Complex", … ironcalc3+4i hyperformula3+4i libreoffice3+4i formulas#NUM! pycel#NAME?
financial-timevalue/cacd3d =IPMT(0.05/12, 1, 360, -200000) 833.333333 gsheets833.333 excel833.333 lattice833.333 ironcalc833.333 hyperformula833.33333333 libreoffice833.333 formulas#NUM! pycel#NAME?
financial-timevalue/2fe8d6 =PPMT(0.05/12, 5, 360, -200000) + IPMT(0.05/12, 5, 360, -200000) 1073.64 gsheets1073.64 excel1073.64 lattice1073.64 ironcalc1073.64 hyperformula1073.643246 libreoffice1073.64 formulas#NUM! pycel#NAME?