DV-0002
excel, formulas, hyperformula, ironcalc, libreoffice, pycel: function not implemented — ADD, AVERAGE.WEIGHTED, DIVIDE (+12 more)
Subjects (15)
Tests (93)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
ADD/add-numbers |
=ADD(2, 3) |
5 | gsheets5 | excel#NAME? | lattice5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ADD/add-negatives |
=ADD(-4, 1) |
-3 | gsheets-3 | excel#NAME? | lattice-3 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ADD/add-zero |
=ADD(0, 0) |
0 | gsheets0 | excel#NAME? | lattice0 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ADD/add-decimals |
=ADD(0.1, 0.2) |
0.300000 | gsheets0.300000 | excel#NAME? | lattice0.300000 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ADD/add-boolean-coerces-to-1 |
=ADD(TRUE, 1) |
2 | gsheets2 | excel#NAME? | lattice#VALUE! | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ADD/add-string-number-coerces |
=ADD("2", 3) |
5 | gsheets5 | excel#NAME? | lattice5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ADD/add-matches-plus-operator |
=ADD(7, 11)=7+11 |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
MINUS/minus-numbers |
=MINUS(10, 3) |
7 | gsheets7 | excel#NAME? | lattice7 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
MINUS/minus-negative-result |
=MINUS(3, 10) |
-7 | gsheets-7 | excel#NAME? | lattice-7 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
MINUS/minus-zero |
=MINUS(5, 5) |
0 | gsheets0 | excel#NAME? | lattice0 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
MINUS/minus-boolean-coerces |
=MINUS(TRUE, FALSE) |
1 | gsheets1 | excel#NAME? | lattice1 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
MINUS/minus-string-coerces |
=MINUS("10", "4") |
6 | gsheets6 | excel#NAME? | lattice6 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
MINUS/minus-matches-minus-operator |
=MINUS(9, 4)=9-4 |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
MULTIPLY/multiply-numbers |
=MULTIPLY(6, 7) |
42 | gsheets42 | excel#NAME? | lattice42 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
MULTIPLY/multiply-by-zero |
=MULTIPLY(123, 0) |
0 | gsheets0 | excel#NAME? | lattice0 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
MULTIPLY/multiply-negative |
=MULTIPLY(-3, 4) |
-12 | gsheets-12 | excel#NAME? | lattice-12 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
MULTIPLY/multiply-boolean-coerces |
=MULTIPLY(TRUE, 5) |
5 | gsheets5 | excel#NAME? | lattice5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
MULTIPLY/multiply-string-coerces |
=MULTIPLY("3", 4) |
12 | gsheets12 | excel#NAME? | lattice12 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
MULTIPLY/multiply-matches-star-operator |
=MULTIPLY(6, 7)=6*7 |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
DIVIDE/divide-numbers |
=DIVIDE(20, 4) |
5 | gsheets5 | excel#NAME? | lattice5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
DIVIDE/divide-by-zero |
=DIVIDE(1, 0) |
#DIV/0! | gsheets#DIV/0! | excel#NAME? | lattice#DIV/0! | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
DIVIDE/divide-fractional |
=DIVIDE(1, 3) |
0.333333 | gsheets0.333333 | excel#NAME? | lattice0.333333 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
DIVIDE/divide-negative |
=DIVIDE(-12, 4) |
-3 | gsheets-3 | excel#NAME? | lattice-3 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
DIVIDE/divide-string-coerces |
=DIVIDE("10", "2") |
5 | gsheets5 | excel#NAME? | lattice5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
DIVIDE/divide-matches-slash-operator |
=DIVIDE(100, 4)=100/4 |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UMINUS/uminus-positive |
=UMINUS(5) |
-5 | gsheets-5 | excel#NAME? | lattice-5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UMINUS/uminus-negative |
=UMINUS(-3) |
3 | gsheets3 | excel#NAME? | lattice3 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UMINUS/uminus-zero |
=UMINUS(0) |
0 | gsheets0 | excel#NAME? | lattice0 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UMINUS/uminus-boolean-coerces |
=UMINUS(TRUE) |
-1 | gsheets-1 | excel#NAME? | lattice-1 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UMINUS/uminus-string-coerces |
=UMINUS("7") |
-7 | gsheets-7 | excel#NAME? | lattice-7 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UMINUS/uminus-matches-unary-minus |
=UMINUS(42)=-42 |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UPLUS/uplus-positive |
=UPLUS(5) |
5 | gsheets5 | excel#NAME? | lattice5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UPLUS/uplus-negative |
=UPLUS(-3) |
-3 | gsheets-3 | excel#NAME? | lattice-3 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UPLUS/uplus-zero |
=UPLUS(0) |
0 | gsheets0 | excel#NAME? | lattice0 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UPLUS/uplus-boolean |
=UPLUS(TRUE) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UPLUS/uplus-string |
=UPLUS("hello") |
hello | gsheetshello | excel#NAME? | latticehello | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UPLUS/uplus-numeric-string |
=UPLUS("3.14") |
3.14 | gsheets3.14 | excel#NAME? | lattice3.14 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UNARY_PERCENT/unary-percent-fifty |
=UNARY_PERCENT(50) |
0.5 | gsheets0.5 | excel#NAME? | lattice0.5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UNARY_PERCENT/unary-percent-one |
=UNARY_PERCENT(1) |
0.01 | gsheets0.01 | excel#NAME? | lattice0.01 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UNARY_PERCENT/unary-percent-zero |
=UNARY_PERCENT(0) |
0 | gsheets0 | excel#NAME? | lattice0 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UNARY_PERCENT/unary-percent-negative |
=UNARY_PERCENT(-25) |
-0.25 | gsheets-0.25 | excel#NAME? | lattice-0.25 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UNARY_PERCENT/unary-percent-hundred |
=UNARY_PERCENT(100) |
1 | gsheets1 | excel#NAME? | lattice1 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UNARY_PERCENT/unary-percent-string-coerces |
=UNARY_PERCENT("50") |
0.5 | gsheets0.5 | excel#NAME? | lattice0.5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
UNARY_PERCENT/unary-percent-matches-percent-operator |
=UNARY_PERCENT(75)=75% |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
EQ/eq-numbers-equal |
=EQ(1, 1) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
EQ/eq-numbers-unequal |
=EQ(1, 2) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
EQ/eq-strings-equal |
=EQ("abc", "abc") |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
EQ/eq-case-sensitivity |
=EQ("ABC", "abc") |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
EQ/eq-string-matches-number |
=EQ("1", 1) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
EQ/eq-boolean-to-number |
=EQ(TRUE, 1) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
EQ/eq-empty-vs-zero |
=EQ("", 0) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
EQ/eq-matches-equals-operator |
=EQ(5, 5)=(5=5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
NE/ne-numbers-unequal |
=NE(1, 2) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
NE/ne-numbers-equal |
=NE(1, 1) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
NE/ne-strings-unequal |
=NE("a", "b") |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
NE/ne-string-vs-number |
=NE("1", 1) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
NE/ne-case-difference |
=NE("ABC", "abc") |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
NE/ne-matches-neq-operator |
=NE(1, 2)=(1<>2) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
GT/gt-greater |
=GT(5, 3) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
GT/gt-equal |
=GT(5, 5) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
GT/gt-less |
=GT(2, 5) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
GT/gt-strings-lex |
=GT("b", "a") |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
GT/gt-string-vs-number |
=GT("10", 9) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
GT/gt-matches-gt-operator |
=GT(5, 3)=(5>3) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
GTE/gte-greater |
=GTE(5, 3) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
GTE/gte-equal |
=GTE(5, 5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
GTE/gte-less |
=GTE(2, 5) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
GTE/gte-string-vs-number |
=GTE("5", 5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
GTE/gte-matches-gte-operator |
=GTE(5, 5)=(5>=5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
LT/lt-less |
=LT(2, 5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
LT/lt-equal |
=LT(5, 5) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
LT/lt-greater |
=LT(5, 2) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
LT/lt-strings-lex |
=LT("a", "b") |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
LT/lt-string-vs-number |
=LT("9", 10) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
LT/lt-matches-lt-operator |
=LT(2, 5)=(2<5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
LTE/lte-less |
=LTE(2, 5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
LTE/lte-equal |
=LTE(5, 5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
LTE/lte-greater |
=LTE(5, 2) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
LTE/lte-string-vs-number |
=LTE("5", 5) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
LTE/lte-matches-lte-operator |
=LTE(2, 5)=(2<=5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ISBETWEEN/isbetween-inside |
=ISBETWEEN(5, 1, 10) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ISBETWEEN/isbetween-below |
=ISBETWEEN(0, 1, 10) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ISBETWEEN/isbetween-above |
=ISBETWEEN(11, 1, 10) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ISBETWEEN/isbetween-lower-boundary-default-inclusive |
=ISBETWEEN(1, 1, 10) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ISBETWEEN/isbetween-upper-boundary-default-inclusive |
=ISBETWEEN(10, 1, 10) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ISBETWEEN/isbetween-lower-exclusive-boundary |
=ISBETWEEN(1, 1, 10, FALSE) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ISBETWEEN/isbetween-upper-exclusive-boundary |
=ISBETWEEN(10, 1, 10, TRUE, FALSE) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ISBETWEEN/isbetween-both-exclusive-inside |
=ISBETWEEN(5, 1, 10, FALSE, FALSE) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ISBETWEEN/isbetween-string-value |
=ISBETWEEN("5", 1, 10) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
ISBETWEEN/isbetween-negative-range |
=ISBETWEEN(-5, -10, -1) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
AVERAGE.WEIGHTED/average-weighted-basic |
=AVERAGE.WEIGHTED({1,2,3}, {1,1,1}) |
2 | gsheets2 | excel#NAME? | lattice2 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
AVERAGE.WEIGHTED/average-weighted-skewed |
=AVERAGE.WEIGHTED({1,2,3}, {1,2,3}) |
2.33333 | gsheets2.33333 | excel#NAME? | lattice2.33333 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |
AVERAGE.WEIGHTED/average-weighted-grid |
=AVERAGE.WEIGHTED(A1:A3, B1:B3) |
2.33333 | gsheets2.33333 | excel#NAME? | lattice2.33333 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas#NAME? | pycel#NAME? |