DV-0067
formulas: different argument interpretation — CEILING.PRECISE, ISO.CEILING
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 |
|---|---|---|---|---|---|---|---|---|---|---|
CEILING.PRECISE/ceiling-precise-negative |
=CEILING.PRECISE(-4.3) |
-4 | gsheets-4 | excel-4 | lattice-4 | ironcalc-4 | hyperformula-4 | libreoffice— | formulas5 | pycel#NAME? |
ISO.CEILING/iso-ceiling-negative |
=ISO.CEILING(-4.3) |
-4 | gsheets-4 | excel-4 | lattice-4 | ironcalc-4 | hyperformula-4 | libreoffice— | formulas5 | pycel#NAME? |