assay

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
IMDIV/imdiv-by-real =IMDIV("6+8i", "2") 3+4i gsheets3+4i excel3+4i lattice3+4i ironcalc3+4i hyperformula3+4i libreoffice— formulas#NUM! pycel#NAME?
IPMT/ipmt-first-period-mortgage =IPMT(0.05/12, 1, 360, -200000) 833.333333 gsheets833.333 excel833.333 lattice833.333 ironcalc833.333 hyperformula833.33333333 libreoffice— formulas#NUM! pycel#NAME?
PPMT/ppmt-ipmt-plus-ppmt-equals-pmt =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 libreoffice— formulas#NUM! pycel#NAME?