DV-0143
excel, formulas, gsheets, lattice: numeric precision differs — NOMINAL
Subjects (1)
Tests (1)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
financial-timevalue/85b26a |
=NOMINAL(0.126825030131969, 12) |
0.12 | gsheets0.120000 | excel0.120000 | lattice0.120000 | ironcalc0.12 | hyperformula0.12 | libreoffice0.12 | formulas0.120000 | pycel#NAME? |