DV-0046
hyperformula: different argument interpretation — PMT, PPMT
Subjects (2)
Tests (3)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
financial-timevalue/136a75 |
=PMT(0.05/12, 360, -200000) |
1073.64 | gsheets1073.64 | excel1073.64 | lattice1073.64 | ironcalc1073.64 | hyperformula1073.643246 | libreoffice1073.64 | formulas1073.64 | 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? |
financial-timevalue/6f263c |
=PPMT(0.05/12, 361, 360, -200000) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula1073.643246 | libreoffice#VALUE! | formulas#NUM! | pycel#NAME? |