DV-0060
libreoffice: different argument interpretation — PMT, PPMT
Subjects (2)
Tests (2)
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? |