DV-0006
hyperformula: function not implemented — AND, AVERAGE, AVERAGEIFS (+19 more)
Subjects (22)
Tests (53)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
divergences/4e0f08 |
=TRUE+1 |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula#NAME? | libreoffice2 | formulas2 | pycel2 |
error-handling/dbea8d |
=INDIRECT("ZZZ99999") |
— | gsheets— | excel#REF! | lattice— | ironcalc#REF! | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
error-handling/0e158d |
=VLOOKUP("missing", {1,2;3,4}, 2, FALSE) |
#N/A | gsheets#N/A | excel#N/A | lattice#N/A | ironcalc#N/A | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
error-handling/1054e8 |
=IF(FALSE, #N/A, "ok") |
ok | gsheetsok | excelok | latticeok | ironcalcok | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
error-handling/f38b4d |
=IF(TRUE, #N/A, "ok") |
#N/A | gsheets#N/A | excel#N/A | lattice#N/A | ironcalc#N/A | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
error-handling/8f96b3 |
=ERROR.TYPE(1/0) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
error-handling/5eafca |
=ERROR.TYPE(#N/A) |
7 | gsheets7 | excel7 | lattice7 | ironcalc7 | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
error-handling/9e8ade |
=ERROR.TYPE("a"+1) |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
error-handling/96c8b4 |
=ERROR.TYPE(42) |
#N/A | gsheets#N/A | excel#N/A | lattice#N/A | ironcalc#N/A | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
info/b17004 |
=N(TRUE) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#NAME? | libreoffice1 | formulastrue | pycel1 |
info/6567ec |
=N(FALSE) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula#NAME? | libreoffice0 | formulasfalse | pycel0 |
logical/27b6f8 |
=IF(TRUE, 1, 2) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#NAME? | libreoffice1 | formulas1 | pycel1 |
logical/f59750 |
=IF(FALSE, 1, 2) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula#NAME? | libreoffice2 | formulas2 | pycel2 |
logical/b9debc |
=IF(2>3, TRUE, FALSE) |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformula#NAME? | libreofficefalse | formulasfalse | pycelfalse |
logical/48318a |
=AND(TRUE, TRUE, TRUE) |
true | gsheetstrue | exceltrue | latticetrue | ironcalctrue | hyperformula#NAME? | libreofficetrue | formulastrue | pyceltrue |
logical/646f43 |
=AND(TRUE, FALSE, TRUE) |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformula#NAME? | libreofficefalse | formulasfalse | pycelfalse |
logical/b50b2c |
=OR(FALSE, TRUE, FALSE) |
true | gsheetstrue | exceltrue | latticetrue | ironcalctrue | hyperformula#NAME? | libreofficetrue | formulastrue | pyceltrue |
logical/c0f2e8 |
=OR(FALSE, FALSE, FALSE) |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformula#NAME? | libreofficefalse | formulasfalse | pycelfalse |
logical/a8974a |
=NOT(TRUE) |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformula#NAME? | libreofficefalse | formulasfalse | pycelfalse |
logical/686333 |
=NOT(FALSE) |
true | gsheetstrue | exceltrue | latticetrue | ironcalctrue | hyperformula#NAME? | libreofficetrue | formulastrue | pyceltrue |
lookup-longtail/2060ee |
=INDIRECT("A1") |
42 | gsheets42 | excel42 | lattice42 | ironcalc42 | hyperformula#NAME? | libreoffice42 | formulas42 | pycel42 |
lookup-longtail/653ff9 |
=INDIRECT("B3") |
hello | gsheetshello | excelhello | latticehello | ironcalchello | hyperformula#NAME? | libreofficehello | formulashello | pycelhello |
lookup-longtail/f166ec |
=SUM(INDIRECT("A1:A3")) |
6 | gsheets6 | excel6 | lattice6 | ironcalc6 | hyperformula#NAME? | libreoffice6 | formulas6 | pycel0 |
lookup-longtail/533001 |
=LOOKUP(2, A1:A3, B1:B3) |
banana | gsheetsbanana | excelbanana | latticebanana | ironcalcbanana | hyperformula#NAME? | libreofficebanana | formulasbanana | pycelbanana |
lookup-longtail/2eed78 |
=LOOKUP(4, A1:A3, B1:B3) |
mid | gsheetsmid | excelmid | latticemid | ironcalcmid | hyperformula#NAME? | libreofficemid | formulasmid | pycelmid |
lookup-longtail/f2b34f |
=LOOKUP(20, A1:A3) |
20 | gsheets20 | excel20 | lattice20 | ironcalc20 | hyperformula#NAME? | libreoffice20 | formulas20 | pycel20 |
lookup-longtail/2086c6 |
=LOOKUP(5, A1:A3, B1:B3) |
#N/A | gsheets#N/A | excel#N/A | lattice#N/A | ironcalc#N/A | hyperformula#NAME? | libreoffice#N/A | formulas#N/A | pycel#N/A |
lookup-longtail/8bd5ce |
=LOOKUP(99, A1:A3, B1:B3) |
c | gsheetsc | excelc | latticec | ironcalcc | hyperformula#NAME? | libreofficec | formulasc | pycelc |
lookup/ba9d81 |
=VLOOKUP(2, A1:B3, 2, FALSE) |
banana | gsheetsbanana | excelbanana | latticebanana | ironcalcbanana | hyperformula#NAME? | libreofficebanana | formulasbanana | pycelbanana |
lookup/0974ec |
=VLOOKUP(99, A1:B2, 2, FALSE) |
#N/A | gsheets#N/A | excel#N/A | lattice#N/A | ironcalc#N/A | hyperformula#NAME? | libreoffice#N/A | formulas#N/A | pycel#N/A |
lookup/ea1fcc |
=HLOOKUP(2, A1:C2, 2, FALSE) |
banana | gsheetsbanana | excelbanana | latticebanana | ironcalcbanana | hyperformula#NAME? | libreofficebanana | formulasbanana | pycelbanana |
math-longtail/ca8209 |
=RANDARRAY(2, 2) |
[object Object] | gsheets[0.0466877, 0.815970, 0.480943, 0.299562] | excel[0.177176, 0.795012, 0.471946, 0.257387] | lattice[0.790534, 0.881463, 0.389858, 0.199495] | ironcalc#NAME? | hyperformula#NAME? | libreoffice#NAME? | formulas#NAME? | pycel#NAME? |
statistical-analytics/851aff |
=INTERCEPT(B1:B3, A1:A3) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#NAME? | libreoffice1 | formulas1 | pycel1.00000 |
statistical-descriptive/3d2419 |
=AVERAGEIFS(E1:E5, D1:D5, "A") |
30 | gsheets30 | excel30 | lattice30 | ironcalc30 | hyperformula#NAME? | libreoffice30 | formulas30 | pycel30 |
statistical-descriptive/649843 |
=AVERAGEIFS(E1:E5, D1:D5, "A", E1:E5, ">15") |
40 | gsheets40 | excel40 | lattice40 | ironcalc40 | hyperformula#NAME? | libreoffice40 | formulas40 | pycel40 |
statistical-descriptive/35c785 |
=AVERAGEIFS(A1:A3, B1:B3, "q") |
#DIV/0! | gsheets#DIV/0! | excel#DIV/0! | lattice#DIV/0! | ironcalc#DIV/0! | hyperformula#NAME? | libreoffice#DIV/0! | formulas#DIV/0! | pycel#DIV/0! |
type-coercion/aa556d |
=TRUE+0 |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/e7ef6e |
=FALSE+0 |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/b322a2 |
=TRUE+1 |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/cf6f56 |
=TRUE*TRUE |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/261fa9 |
=TRUE-FALSE |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/255ef9 |
=SUM(TRUE, FALSE, TRUE) |
2 | gsheets2 | excel2 | lattice2 | ironcalc0 | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/3e62ee |
=AVERAGE(TRUE, FALSE, TRUE) |
0.666667 | gsheets0.666667 | excel0.666667 | lattice#DIV/0! | ironcalc0.666666667 | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/31a795 |
=TRUE&"x" |
TRUEx | gsheetsTRUEx | excelTRUEx | latticeTRUEx | ironcalcTRUEx | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/85af0e |
=1&TRUE |
1TRUE | gsheets1TRUE | excel1TRUE | lattice1TRUE | ironcalc1TRUE | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/e78ee8 |
=TRUE=1 |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/cccf83 |
=-TRUE |
-1 | gsheets-1 | excel-1 | lattice-1 | ironcalc-1 | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/93d26b |
=--TRUE |
1 | gsheets1 | excel1 | lattice1 | ironcalctrue | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/71c9e5 |
=--FALSE |
0 | gsheets0 | excel0 | lattice0 | ironcalcfalse | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/b17004 |
=N(TRUE) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/6567ec |
=N(FALSE) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
type-coercion/1ae802 |
=N({TRUE,FALSE,TRUE}) |
[1, 0, 1] | gsheets[1, 0, 1] | excel[1, 0, 1] | lattice[1, 0, 1] | ironcalc#N/IMPL! | hyperformula#NAME? | libreoffice— | formulas— | pycel— |
volatile/0ca12a |
=ROWS(RANDARRAY(2,3))&"x"&COLUMNS(RANDARRAY(2,3)) |
2x3 | gsheets2x3 | excel2x3 | lattice2x3 | ironcalc#NAME? | hyperformula#NAME? | libreoffice— | formulas— | pycel— |