DV-0050
formulas, hyperformula, ironcalc, pycel: function not implemented — DOLLAR
Subjects (1)
Tests (3)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
DOLLAR/dollar-basic |
=DOLLAR(1234.567) |
$1,234.57 | gsheets$1,234.57 | excel$1,234.57 | lattice$1,234.57 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
DOLLAR/dollar-2-decimals |
=DOLLAR(1234.567, 2) |
$1,234.57 | gsheets$1,234.57 | excel$1,234.57 | lattice$1,234.57 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
DOLLAR/dollar-zero-decimals |
=DOLLAR(1234.567, 0) |
$1,235 | gsheets$1,235 | excel$1,235 | lattice$1,235 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |