assay

DV-0059

excel: different argument interpretation — PMT, PPMT

Cause
arg-semantics
Category
value
Diverging engines
excel
Behavior signature
1073.6432460242781
Test count
2
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (2)

PMT PPMT

Tests (2)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
PMT/pmt-monthly-mortgage =PMT(0.05/12, 360, -200000) 1073.64 gsheets1073.64 excel1073.64 lattice1073.64 ironcalc1073.64 hyperformula1073.643246 libreoffice— formulas1073.64 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?