DV-0061
formulas: different argument interpretation — ISNUMBER, N
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 |
|---|---|---|---|---|---|---|---|---|---|---|
ISNUMBER/isnumber-of-numeric-text |
=ISNUMBER("42") |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformulafalse | libreoffice— | formulastrue | pycelfalse |
N/n-of-true-info |
=N(TRUE) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#NAME? | libreoffice— | formulastrue | pycel1 |