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 |
|---|---|---|---|---|---|---|---|---|---|---|
operator/90a100 |
=ADD(2, 3) |
5 | gsheets5 | excel#NAME? | lattice5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/0aa158 |
=ADD(-4, 1) |
-3 | gsheets-3 | excel#NAME? | lattice-3 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/1d164a |
=ADD(0, 0) |
0 | gsheets0 | excel#NAME? | lattice0 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/21e9ba |
=ADD(0.1, 0.2) |
0.300000 | gsheets0.300000 | excel#NAME? | lattice0.300000 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/eb257a |
=ADD(TRUE, 1) |
2 | gsheets2 | excel#NAME? | lattice#VALUE! | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/a6e889 |
=ADD("2", 3) |
5 | gsheets5 | excel#NAME? | lattice#VALUE! | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/93bef3 |
=ADD(7, 11)=7+11 |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/db589b |
=MINUS(10, 3) |
7 | gsheets7 | excel#NAME? | lattice7 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/4c1ba8 |
=MINUS(3, 10) |
-7 | gsheets-7 | excel#NAME? | lattice-7 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/d8f194 |
=MINUS(5, 5) |
0 | gsheets0 | excel#NAME? | lattice0 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/86c06a |
=MINUS(TRUE, FALSE) |
1 | gsheets1 | excel#NAME? | lattice1 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/418487 |
=MINUS("10", "4") |
6 | gsheets6 | excel#NAME? | lattice6 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/ff3e43 |
=MINUS(9, 4)=9-4 |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/ad2db1 |
=MULTIPLY(6, 7) |
42 | gsheets42 | excel#NAME? | lattice42 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/0e1837 |
=MULTIPLY(123, 0) |
0 | gsheets0 | excel#NAME? | lattice0 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/f7cf20 |
=MULTIPLY(-3, 4) |
-12 | gsheets-12 | excel#NAME? | lattice-12 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/5bdf1e |
=MULTIPLY(TRUE, 5) |
5 | gsheets5 | excel#NAME? | lattice5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/5c7b87 |
=MULTIPLY("3", 4) |
12 | gsheets12 | excel#NAME? | lattice12 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/29c892 |
=MULTIPLY(6, 7)=6*7 |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/c6c74f |
=DIVIDE(20, 4) |
5 | gsheets5 | excel#NAME? | lattice5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/138f72 |
=DIVIDE(1, 0) |
#DIV/0! | gsheets#DIV/0! | excel#NAME? | lattice#DIV/0! | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/fa7a8a |
=DIVIDE(1, 3) |
0.333333 | gsheets0.333333 | excel#NAME? | lattice0.333333 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/6dcb32 |
=DIVIDE(-12, 4) |
-3 | gsheets-3 | excel#NAME? | lattice-3 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/c16201 |
=DIVIDE("10", "2") |
5 | gsheets5 | excel#NAME? | lattice5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/e1f847 |
=DIVIDE(100, 4)=100/4 |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/63dc07 |
=UMINUS(5) |
-5 | gsheets-5 | excel#NAME? | lattice-5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/0f8717 |
=UMINUS(-3) |
3 | gsheets3 | excel#NAME? | lattice3 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/c361d2 |
=UMINUS(0) |
0 | gsheets0 | excel#NAME? | lattice0 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/83cbbf |
=UMINUS(TRUE) |
-1 | gsheets-1 | excel#NAME? | lattice-1 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/37ba76 |
=UMINUS("7") |
-7 | gsheets-7 | excel#NAME? | lattice-7 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/69644f |
=UMINUS(42)=-42 |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/934e46 |
=UPLUS(5) |
5 | gsheets5 | excel#NAME? | lattice5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/f94768 |
=UPLUS(-3) |
-3 | gsheets-3 | excel#NAME? | lattice-3 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/cd4fbd |
=UPLUS(0) |
0 | gsheets0 | excel#NAME? | lattice0 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/a319c4 |
=UPLUS(TRUE) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/a65d22 |
=UPLUS("hello") |
hello | gsheetshello | excel#NAME? | latticehello | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/240955 |
=UPLUS("3.14") |
3.14 | gsheets3.14 | excel#NAME? | lattice3.14 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/560727 |
=UNARY_PERCENT(50) |
0.5 | gsheets0.5 | excel#NAME? | lattice0.5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/6d265c |
=UNARY_PERCENT(1) |
0.01 | gsheets0.01 | excel#NAME? | lattice0.01 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/5c442d |
=UNARY_PERCENT(0) |
0 | gsheets0 | excel#NAME? | lattice0 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/e6adbb |
=UNARY_PERCENT(-25) |
-0.25 | gsheets-0.25 | excel#NAME? | lattice-0.25 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/207fb5 |
=UNARY_PERCENT(100) |
1 | gsheets1 | excel#NAME? | lattice1 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/cb7e15 |
=UNARY_PERCENT("50") |
0.5 | gsheets0.5 | excel#NAME? | lattice0.5 | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/1d402b |
=UNARY_PERCENT(75)=75% |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/04e93a |
=EQ(1, 1) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/29201c |
=EQ(1, 2) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/c8790e |
=EQ("abc", "abc") |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/a5ed35 |
=EQ("ABC", "abc") |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/83fbd4 |
=EQ("1", 1) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/a9edcc |
=EQ(TRUE, 1) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/4896ab |
=EQ("", 0) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/b53434 |
=EQ(5, 5)=(5=5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/a4c97c |
=NE(1, 2) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/64a81e |
=NE(1, 1) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/c702b7 |
=NE("a", "b") |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/9fa3bc |
=NE("1", 1) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/db99ba |
=NE("ABC", "abc") |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/ce462d |
=NE(1, 2)=(1<>2) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/1eebe3 |
=GT(5, 3) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/6d9398 |
=GT(5, 5) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/f0d982 |
=GT(2, 5) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/bb1000 |
=GT("b", "a") |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/ddef45 |
=GT("10", 9) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/ef291b |
=GT(5, 3)=(5>3) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/97c93d |
=GTE(5, 3) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/60ee3a |
=GTE(5, 5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/007266 |
=GTE(2, 5) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/d5deea |
=GTE("5", 5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/e9e4b0 |
=GTE(5, 5)=(5>=5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/590a48 |
=LT(2, 5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/a19d04 |
=LT(5, 5) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/271907 |
=LT(5, 2) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/ead751 |
=LT("a", "b") |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/603b20 |
=LT("9", 10) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/89401d |
=LT(2, 5)=(2<5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/6c9de7 |
=LTE(2, 5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/d7a656 |
=LTE(5, 5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/cbea3c |
=LTE(5, 2) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/00930d |
=LTE("5", 5) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/175234 |
=LTE(2, 5)=(2<=5) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/de197a |
=ISBETWEEN(5, 1, 10) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/79334a |
=ISBETWEEN(0, 1, 10) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/81f240 |
=ISBETWEEN(11, 1, 10) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/7f4682 |
=ISBETWEEN(1, 1, 10) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/f3d8eb |
=ISBETWEEN(10, 1, 10) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/8d3b9a |
=ISBETWEEN(1, 1, 10, FALSE) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/f586b5 |
=ISBETWEEN(10, 1, 10, TRUE, FALSE) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/610e14 |
=ISBETWEEN(5, 1, 10, FALSE, FALSE) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/421a78 |
=ISBETWEEN("5", 1, 10) |
false | gsheetsfalse | excel#NAME? | latticefalse | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
operator/d4e3c9 |
=ISBETWEEN(-5, -10, -1) |
true | gsheetstrue | excel#NAME? | latticetrue | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
statistical-descriptive/a84e6c |
=AVERAGE.WEIGHTED({1,2,3}, {1,1,1}) |
2 | gsheets2 | excel#NAME? | lattice#VALUE! | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
statistical-descriptive/702ac0 |
=AVERAGE.WEIGHTED({1,2,3}, {1,2,3}) |
2.33333 | gsheets2.33333 | excel#NAME? | lattice#VALUE! | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
statistical-descriptive/772ab9 |
=AVERAGE.WEIGHTED(A1:A3, B1:B3) |
2.33333 | gsheets2.33333 | excel#NAME? | lattice#VALUE! | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |