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 |
|---|---|---|---|---|---|---|---|---|---|---|
math-longtail/7b9b02 |
=CEILING.PRECISE(-4.3) |
-4 | gsheets-4 | excel-4 | lattice-4 | ironcalc-4 | hyperformula-4 | libreoffice#NAME? | formulas5 | pycel-4 |
math-longtail/7945d2 |
=ISO.CEILING(-4.3) |
-4 | gsheets-4 | excel-4 | lattice-4 | ironcalc-4 | hyperformula-4 | libreoffice-4 | formulas5 | pycel#NAME? |