DV-0001
pycel: function not implemented — AVEDEV, AVERAGEA, COLUMNS (+75 more)
Subjects (78)
AVEDEV AVERAGEA COLUMNS COMPLEX CORREL COUNTA CUMIPMT CUMPRINC DATEDIF DAYS360 DB DDB DELTA DEVSQ DOLLARDE DOLLARFR EFFECT EXACT FISHER FISHERINV FV GAMMALN GEOMEAN HARMEAN HOUR IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMDIV IMPRODUCT IMREAL IMSUB IMSUM IPMT IRR ISO.CEILING ISPMT ISREF MAXA MEDIAN MINA MINUTE MIRR MROUND NETWORKDAYS NETWORKDAYS.INTL NOMINAL NPER PEARSON PMT PPMT PRODUCT REPT ROMAN ROWS RSQ SEARCH SECOND SKEW SLN SQRTPI STANDARDIZE STEYX SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 SYD T TBILLPRICE TIME VARA VARPA WEEKNUM WORKDAY WORKDAY.INTL XNPV
Tests (200)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
array-longtail/8d6ea4 |
=SUMX2MY2({1,2,3}, {4,5,6}) |
-63 | gsheets-63 | excel-63 | lattice-63 | ironcalc-63 | hyperformula-63 | libreoffice-63 | formulas-63 | pycel#NAME? |
array-longtail/d7eeeb |
=SUMX2MY2({1,2,3}, {1,2,3}) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
array-longtail/a616d1 |
=SUMX2MY2({3}, {2}) |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula5 | libreoffice5 | formulas5 | pycel#NAME? |
array-longtail/0e5ea4 |
=SUMX2PY2({1,2,3}, {4,5,6}) |
91 | gsheets91 | excel91 | lattice91 | ironcalc91 | hyperformula91 | libreoffice91 | formulas91 | pycel#NAME? |
array-longtail/84b3d0 |
=SUMX2PY2({0,0,0}, {0,0,0}) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
array-longtail/2970f2 |
=SUMX2PY2({3}, {4}) |
25 | gsheets25 | excel25 | lattice25 | ironcalc25 | hyperformula25 | libreoffice25 | formulas25 | pycel#NAME? |
array-longtail/56ca49 |
=SUMXMY2({1,2,3}, {4,5,6}) |
27 | gsheets27 | excel27 | lattice27 | ironcalc27 | hyperformula27 | libreoffice27 | formulas27 | pycel#NAME? |
array-longtail/297c96 |
=SUMXMY2({1,2,3}, {1,2,3}) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
array-longtail/21a24e |
=SUMXMY2({5}, {2}) |
9 | gsheets9 | excel9 | lattice9 | ironcalc9 | hyperformula9 | libreoffice9 | formulas9 | pycel#NAME? |
date/1f9dec |
=DATEDIF("2020-01-15", "2025-03-20", "Y") |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula#VALUE! | libreoffice5 | formulas5 | pycel#NAME? |
date/1562bb |
=DATEDIF("2020-01-15", "2025-03-20", "M") |
62 | gsheets62 | excel62 | lattice62 | ironcalc62 | hyperformula#VALUE! | libreoffice62 | formulas62 | pycel#NAME? |
date/1b8fd4 |
=DATEDIF("2025-01-01", "2025-02-01", "D") |
31 | gsheets31 | excel31 | lattice31 | ironcalc31 | hyperformula#VALUE! | libreoffice31 | formulas31 | pycel#NAME? |
date/a701fe |
=DATEDIF("2020-01-15", "2025-03-20", "MD") |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula#VALUE! | libreoffice5 | formulas5 | pycel#NAME? |
date/6ab08d |
=DATEDIF("2020-01-15", "2025-03-20", "YM") |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula#VALUE! | libreoffice2 | formulas2 | pycel#NAME? |
date/a3d5e9 |
=DAYS360("2025-01-15", "2025-03-15") |
60 | gsheets60 | excel60 | lattice60 | ironcalc60 | hyperformula#VALUE! | libreoffice60 | formulas60 | pycel#NAME? |
date/ea35c8 |
=DAYS360("2024-01-01", "2025-01-01") |
360 | gsheets360 | excel360 | lattice360 | ironcalc360 | hyperformula#VALUE! | libreoffice360 | formulas360 | pycel#NAME? |
date/d5f0be |
=DAYS360("2025-01-31", "2025-03-31", TRUE) |
60 | gsheets60 | excel60 | lattice60 | ironcalc60 | hyperformula#VALUE! | libreoffice60 | formulas60 | pycel#NAME? |
date/fc9538 |
=HOUR(TIME(9, 15, 30)) |
9 | gsheets9 | excel9 | lattice9 | ironcalc9 | hyperformula9 | libreoffice9 | formulas9 | pycel#NAME? |
date/c98d72 |
=MINUTE(TIME(9, 15, 30)) |
15 | gsheets15 | excel15 | lattice15 | ironcalc15 | hyperformula15 | libreoffice15 | formulas15 | pycel#NAME? |
date/6f97b2 |
=NETWORKDAYS("2025-03-03", "2025-03-07") |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula#VALUE! | libreoffice5 | formulas5 | pycel#NAME? |
date/bb9294 |
=NETWORKDAYS("2025-03-07", "2025-03-10") |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula#VALUE! | libreoffice2 | formulas2 | pycel#NAME? |
date/27c866 |
=NETWORKDAYS("2025-03-03", "2025-03-07", "2025-03-05") |
4 | gsheets#VALUE! | excel4 | lattice4 | ironcalc#VALUE! | hyperformula#VALUE! | libreoffice#VALUE! | formulas4 | pycel#NAME? |
date/10c040 |
=NETWORKDAYS("2025-03-07", "2025-03-03") |
-5 | gsheets-5 | excel-5 | lattice-5 | ironcalc-5 | hyperformula#VALUE! | libreoffice-5 | formulas-5 | pycel#NAME? |
date/9f3714 |
=NETWORKDAYS.INTL("2025-03-03", "2025-03-07", 1) |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula#VALUE! | libreoffice5 | formulas5 | pycel#NAME? |
date/f72cc6 |
=NETWORKDAYS.INTL("2025-03-03", "2025-03-09", 11) |
6 | gsheets6 | excel6 | lattice6 | ironcalc6 | hyperformula#VALUE! | libreoffice6 | formulas6 | pycel#NAME? |
date/340cf7 |
=NETWORKDAYS.INTL("2025-03-03", "2025-03-09", "0000011") |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula#VALUE! | libreoffice5 | formulas5 | pycel#NAME? |
date/094014 |
=NETWORKDAYS.INTL("2025-03-03", "2025-03-09", "0000001") |
6 | gsheets6 | excel6 | lattice6 | ironcalc6 | hyperformula#VALUE! | libreoffice6 | formulas6 | pycel#NAME? |
date/494718 |
=SECOND(TIME(9, 15, 30)) |
30 | gsheets30 | excel30 | lattice30 | ironcalc30 | hyperformula30 | libreoffice30 | formulas30 | pycel#NAME? |
date/21d254 |
=TIME(0, 0, 0) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
date/98f2b9 |
=WEEKNUM("2025-01-05") |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula#VALUE! | libreoffice2 | formulas2 | pycel#NAME? |
date/881477 |
=WEEKNUM("2025-01-05", 2) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#VALUE! | libreoffice1 | formulas1 | pycel#NAME? |
date/81d5c5 |
=WORKDAY("2025-03-03", 5) |
45726 | gsheets45726 | excel45726 | lattice45726 | ironcalc45726 | hyperformula#VALUE! | libreoffice45726 | formulas45726 | pycel#NAME? |
date/2c2fe9 |
=WORKDAY("2025-03-10", -5) |
45719 | gsheets45719 | excel45719 | lattice45719 | ironcalc45719 | hyperformula#VALUE! | libreoffice45719 | formulas45719 | pycel#NAME? |
date/f474a4 |
=WORKDAY("2025-03-03", 5, "2025-03-05") |
45727 | gsheets#VALUE! | excel45727 | lattice45727 | ironcalc#VALUE! | hyperformula#VALUE! | libreoffice45727 | formulas45727 | pycel#NAME? |
date/79d179 |
=WORKDAY("2025-03-03", 0) |
45719 | gsheets45719 | excel45719 | lattice45719 | ironcalc45719 | hyperformula#VALUE! | libreoffice45719 | formulas45719 | pycel#NAME? |
date/60ae88 |
=WORKDAY.INTL("2025-03-03", 5, 1) |
45726 | gsheets45726 | excel45726 | lattice45726 | ironcalc45726 | hyperformula#VALUE! | libreoffice45726 | formulas45726 | pycel#NAME? |
date/046128 |
=WORKDAY.INTL("2025-03-03", 5, 7) |
45726 | gsheets45726 | excel45726 | lattice45726 | ironcalc45726 | hyperformula#VALUE! | libreoffice45726 | formulas45726 | pycel#NAME? |
date/13319d |
=WORKDAY.INTL("2025-03-03", 5, "0000011") |
45726 | gsheets45726 | excel45726 | lattice45726 | ironcalc45726 | hyperformula#VALUE! | libreoffice45726 | formulas45726 | pycel#NAME? |
date/2fa3fa |
=WORKDAY.INTL("2025-03-03", 5, "0000001") |
45724 | gsheets45724 | excel45724 | lattice45724 | ironcalc45724 | hyperformula#VALUE! | libreoffice45724 | formulas45724 | pycel#NAME? |
engineering/109ff6 |
=DELTA(5, 5) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
engineering/ccf81e |
=DELTA(5, 6) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
engineering/60933c |
=DELTA(0) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
engineering/68b0bf |
=DELTA(1) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
engineering/c9011f |
=COMPLEX(3, 4, "j") |
3+4j | gsheets3+4j | excel3+4j | lattice{__typeof: "Complex", … | ironcalc3+4j | hyperformula3+4j | libreoffice3+4j | formulas3+4j | pycel#NAME? |
engineering/9d56bd |
=IMABS("3+4i") |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula5 | libreoffice5 | formulas5 | pycel#NAME? |
engineering/ba70a2 |
=IMABS("5") |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula5 | libreoffice5 | formulas5 | pycel#NAME? |
engineering/22a578 |
=IMABS("4i") |
4 | gsheets4 | excel4 | lattice4 | ironcalc4 | hyperformula4 | libreoffice4 | formulas4 | pycel#NAME? |
engineering/0fea0d |
=IMAGINARY("3+4i") |
4 | gsheets4 | excel4 | lattice4 | ironcalc4 | hyperformula4 | libreoffice4 | formulas4 | pycel#NAME? |
engineering/7527a9 |
=IMAGINARY("5") |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
engineering/008323 |
=IMAGINARY("3-4i") |
-4 | gsheets-4 | excel-4 | lattice-4 | ironcalc-4 | hyperformula-4 | libreoffice-4 | formulas-4 | pycel#NAME? |
engineering/96cf3c |
=IMREAL("3+4i") |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula3 | libreoffice3 | formulas3 | pycel#NAME? |
engineering/75f4ba |
=IMREAL("4i") |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
engineering/f9b9bc |
=IMREAL("-3+4i") |
-3 | gsheets-3 | excel-3 | lattice-3 | ironcalc-3 | hyperformula-3 | libreoffice-3 | formulas-3 | pycel#NAME? |
engineering/07c64a |
=IMARGUMENT("1") |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
engineering/8c0e08 |
=IMCONJUGATE("3+4i") |
3-4i | gsheets3-4i | excel3-4i | lattice{__typeof: "Complex", … | ironcalc3-4i | hyperformula3-4i | libreoffice3-4i | formulas3-4i | pycel#NAME? |
engineering/a0a1dc |
=IMCONJUGATE("3-4i") |
3+4i | gsheets3+4i | excel3+4i | lattice{__typeof: "Complex", … | ironcalc3+4i | hyperformula3+4i | libreoffice3+4i | formulas3+4i | pycel#NAME? |
engineering/6a6bc4 |
=IMCONJUGATE("5") |
5 | gsheets5 | excel5 | lattice{__typeof: "Complex", … | ironcalc5 | hyperformula5 | libreoffice5 | formulas5 | pycel#NAME? |
engineering/333816 |
=IMSUM("1+2i", "3+4i") |
4+6i | gsheets4+6i | excel4+6i | lattice{__typeof: "Complex", … | ironcalc4+6i | hyperformula4+6i | libreoffice4+6i | formulas4+6i | pycel#NAME? |
engineering/d15605 |
=IMSUM("1+i", "2+2i", "3+3i") |
6+6i | gsheets6+6i | excel6+6i | lattice{__typeof: "Complex", … | ironcalc#ERROR! | hyperformula6+6i | libreoffice6+6i | formulas6+6i | pycel#NAME? |
engineering/669dce |
=IMSUM("1+2i", "1-2i") |
2 | gsheets2 | excel2 | lattice{__typeof: "Complex", … | ironcalc2 | hyperformula2 | libreoffice2 | formulas2 | pycel#NAME? |
engineering/da0ae5 |
=IMSUB("5+6i", "2+3i") |
3+3i | gsheets3+3i | excel3+3i | lattice{__typeof: "Complex", … | ironcalc3+3i | hyperformula3+3i | libreoffice3+3i | formulas3+3i | pycel#NAME? |
engineering/135650 |
=IMSUB("3+4i", "3+4i") |
0 | gsheets0 | excel0 | lattice{__typeof: "Complex", … | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
engineering/6ec629 |
=IMSUB("5", "2") |
3 | gsheets3 | excel3 | lattice{__typeof: "Complex", … | ironcalc3 | hyperformula3 | libreoffice3 | formulas3 | pycel#NAME? |
engineering/b9b487 |
=IMPRODUCT("1+2i", "3+4i") |
-5+10i | gsheets-5+10i | excel-5+10i | lattice{__typeof: "Complex", … | ironcalc-5+10i | hyperformula-5+10i | libreoffice-5+10i | formulas-5+10i | pycel#NAME? |
engineering/9c3a01 |
=IMPRODUCT("3+4i", "2") |
6+8i | gsheets6+8i | excel6+8i | lattice{__typeof: "Complex", … | ironcalc6+8i | hyperformula6+8i | libreoffice6+8i | formulas#VALUE! | pycel#NAME? |
engineering/a13e0e |
=IMPRODUCT("i", "i") |
-1 | gsheets-1 | excel-1 | lattice{__typeof: "Complex", … | ironcalc-1 | hyperformula-1 | libreoffice-1 | formulas-1 | pycel#NAME? |
engineering/417a1b |
=IMDIV("-5+10i", "1+2i") |
3+4i | gsheets3+4i | excel3+4i | lattice{__typeof: "Complex", … | ironcalc3+4i | hyperformula3+4i | libreoffice3+4i | formulas3+4i | pycel#NAME? |
engineering/ba4c58 |
=IMDIV("6+8i", "2") |
3+4i | gsheets3+4i | excel3+4i | lattice{__typeof: "Complex", … | ironcalc3+4i | hyperformula3+4i | libreoffice3+4i | formulas#NUM! | pycel#NAME? |
financial-securities/866acd |
=DOLLARDE(1.02, 16) |
1.125 | gsheets1.125 | excel1.125 | lattice1.125 | ironcalc1.125 | hyperformula1.125 | libreoffice1.125 | formulas1.125 | pycel#NAME? |
financial-securities/37ce4c |
=DOLLARDE(1.1, 8) |
1.125 | gsheets1.125 | excel1.125 | lattice1.125 | ironcalc1.125 | hyperformula1.125 | libreoffice1.125 | formulas1.125 | pycel#NAME? |
financial-securities/6d5c52 |
=DOLLARFR(1.125, 16) |
1.02 | gsheets1.02 | excel1.02 | lattice1.02 | ironcalc1.02 | hyperformula1.02 | libreoffice1.02 | formulas1.02 | pycel#NAME? |
financial-securities/c088d8 |
=DOLLARFR(1.125, 8) |
1.1 | gsheets1.1 | excel1.1 | lattice1.1 | ironcalc1.1 | hyperformula1.1 | libreoffice1.1 | formulas1.1 | pycel#NAME? |
financial-securities/676f7f |
=DOLLARFR(1.5, 32) |
1.16 | gsheets1.16 | excel1.16 | lattice1.16 | ironcalc1.16 | hyperformula1.16 | libreoffice1.16 | formulas1.16 | pycel#NAME? |
financial-securities/2fd27f |
=TBILLPRICE(DATE(2008,3,31), DATE(2008,6,1), 0.09) |
98.45 | gsheets98.45 | excel98.45 | lattice98.45 | ironcalc98.45 | hyperformula98.45 | libreoffice98.45 | formulas98.45 | pycel#NAME? |
financial-timevalue/9c7348 |
=CUMIPMT(0.05/12, 360, 100000, 0, 12, 0) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice#VALUE! | formulas#NUM! | pycel#NAME? |
financial-timevalue/eadb99 |
=CUMPRINC(0.05/12, 360, 100000, 1, 12, 2) |
-1884.18 | gsheets-1884.18 | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice#VALUE! | formulas#NUM! | pycel#NAME? |
financial-timevalue/906051 |
=DB(1000000, 100000, 6, 1, 12) |
319000 | gsheets319000 | excel319000 | lattice319000 | ironcalc319000 | hyperformula319000 | libreoffice319000 | formulas319000 | pycel#NAME? |
financial-timevalue/2bdd96 |
=DB(1000000, 100000, 6, 2, 12) |
217239 | gsheets217239 | excel217239 | lattice217239 | ironcalc217239 | hyperformula217239 | libreoffice217239 | formulas217239 | pycel#NAME? |
financial-timevalue/cd4b89 |
=DDB(1000, 100, 10, 1) |
200 | gsheets200.000 | excel200 | lattice200 | ironcalc200 | hyperformula200 | libreoffice200 | formulas200 | pycel#NAME? |
financial-timevalue/3d42b6 |
=DDB(1000, 100, 10, 2) |
160 | gsheets160.000 | excel160 | lattice160 | ironcalc160 | hyperformula160 | libreoffice160 | formulas160.000 | pycel#NAME? |
financial-timevalue/ae34e8 |
=DDB(2400, 300, 10, 1, 1.5) |
360 | gsheets360.000 | excel360 | lattice360 | ironcalc360 | hyperformula360 | libreoffice360 | formulas360 | pycel#NAME? |
financial-timevalue/027d0b |
=EFFECT(0.12, 12) |
0.126825 | gsheets0.126825 | excel0.126825 | lattice0.126825 | ironcalc0.12682503 | hyperformula0.126825 | libreoffice0.126825 | formulas0.126825 | pycel#NAME? |
financial-timevalue/3e7cc5 |
=EFFECT(0.05, 1) |
0.05 | gsheets0.0500000 | excel0.0500000 | lattice0.0500000 | ironcalc0.05 | hyperformula0.05 | libreoffice0.05 | formulas0.0500000 | pycel#NAME? |
financial-timevalue/086aa8 |
=EFFECT(0.05, 0) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice#VALUE! | formulas#NUM! | pycel#NAME? |
financial-timevalue/a51ac7 |
=FV(0.06, 10, -1000) |
13180.79 | gsheets13180.8 | excel13180.8 | lattice13180.8 | ironcalc13180.79 | hyperformula13180.794942 | libreoffice13180.8 | formulas13180.8 | pycel#NAME? |
financial-timevalue/6ed53c |
=FV(0.05, 20, 0, -10000) |
26532.98 | gsheets26533.0 | excel26533.0 | lattice26533.0 | ironcalc26532.98 | hyperformula26532.977051 | libreoffice26533.0 | formulas26533.0 | pycel#NAME? |
financial-timevalue/0ab4dd |
=FV(0, 10, -100) |
1000 | gsheets1000 | excel1000 | lattice1000 | ironcalc1000 | hyperformula1000 | libreoffice1000 | formulas1000 | pycel#NAME? |
financial-timevalue/cacd3d |
=IPMT(0.05/12, 1, 360, -200000) |
833.333333 | gsheets833.333 | excel833.333 | lattice833.333 | ironcalc833.333 | hyperformula833.33333333 | libreoffice833.333 | formulas#NUM! | pycel#NAME? |
financial-timevalue/982b40 |
=IPMT(0.05/12, 0, 360, -200000) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula834.3304699 | libreoffice#VALUE! | formulas#NUM! | pycel#NAME? |
financial-timevalue/7f4f55 |
=IRR(A1:A3) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice#N/A | formulas#NUM! | pycel#NAME? |
financial-timevalue/99ed2c |
=ISPMT(0.05, 0, 5, -1000) |
50 | gsheets50 | excel50 | lattice50 | ironcalc50 | hyperformula50 | libreoffice50 | formulas50 | pycel#NAME? |
financial-timevalue/6467bf |
=ISPMT(0.05, 5, 5, -1000) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
financial-timevalue/312e2b |
=MIRR(A1:A3, 0.1, 0.12) |
#DIV/0! | gsheets#DIV/0! | excel#DIV/0! | lattice#DIV/0! | ironcalc#DIV/0! | hyperformula#DIV/0! | libreoffice#VALUE! | formulas#DIV/0! | pycel#NAME? |
financial-timevalue/85b26a |
=NOMINAL(0.126825030131969, 12) |
0.12 | gsheets0.120000 | excel0.120000 | lattice0.120000 | ironcalc0.12 | hyperformula0.12 | libreoffice0.12 | formulas0.120000 | pycel#NAME? |
financial-timevalue/880ccd |
=NOMINAL(0.05, 1) |
0.05 | gsheets0.0500000 | excel0.0500000 | lattice0.0500000 | ironcalc0.05 | hyperformula0.05 | libreoffice0.05 | formulas0.0500000 | pycel#NAME? |
financial-timevalue/a62e7e |
=NOMINAL(-0.05, 4) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice#VALUE! | formulas#NUM! | pycel#NAME? |
financial-timevalue/9bf6a5 |
=NPER(0, -100, 1000) |
10 | gsheets10 | excel10 | lattice10 | ironcalc10 | hyperformula10 | libreoffice10 | formulas10 | pycel#NAME? |
financial-timevalue/0f3284 |
=NPER(0.1, -1, 10000) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice#NUM! | formulas#NUM! | pycel#NAME? |
financial-timevalue/136a75 |
=PMT(0.05/12, 360, -200000) |
1073.64 | gsheets1073.64 | excel1073.64 | lattice1073.64 | ironcalc1073.64 | hyperformula1073.643246 | libreoffice1073.64 | formulas1073.64 | pycel#NAME? |
financial-timevalue/2cfde2 |
=PMT(0, 12, 12000) |
-1000 | gsheets-1000 | excel-1000 | lattice-1000 | ironcalc-1000 | hyperformula-1000 | libreoffice-1000 | formulas-1000 | pycel#NAME? |
financial-timevalue/2fe8d6 |
=PPMT(0.05/12, 5, 360, -200000) + IPMT(0.05/12, 5, 360, -200000) |
1073.64 | gsheets1073.64 | excel1073.64 | lattice1073.64 | ironcalc1073.64 | hyperformula1073.643246 | libreoffice1073.64 | formulas#NUM! | pycel#NAME? |
financial-timevalue/6f263c |
=PPMT(0.05/12, 361, 360, -200000) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula1073.643246 | libreoffice#VALUE! | formulas#NUM! | pycel#NAME? |
financial-timevalue/c8649b |
=SLN(1000, 100, 10) |
90 | gsheets90 | excel90 | lattice90 | ironcalc90 | hyperformula90 | libreoffice90 | formulas90 | pycel#NAME? |
financial-timevalue/c2acdf |
=SLN(5000, 0, 5) |
1000 | gsheets1000 | excel1000 | lattice1000 | ironcalc1000 | hyperformula1000 | libreoffice1000 | formulas1000 | pycel#NAME? |
financial-timevalue/c946ad |
=SLN(1000, 100, 0) |
#DIV/0! | gsheets#DIV/0! | excel#DIV/0! | lattice#DIV/0! | ironcalc#DIV/0! | hyperformula#DIV/0! | libreoffice#DIV/0! | formulas#DIV/0! | pycel#NAME? |
financial-timevalue/ebe9fb |
=SYD(1000, 100, 10, 1) |
163.636364 | gsheets163.636 | excel163.636 | lattice163.636 | ironcalc163.64 | hyperformula163.63636364 | libreoffice163.636 | formulas163.636 | pycel#NAME? |
financial-timevalue/e95202 |
=SYD(1000, 100, 10, 10) |
16.363636 | gsheets16.3636 | excel16.3636 | lattice16.3636 | ironcalc16.36 | hyperformula16.363636364 | libreoffice16.3636 | formulas16.3636 | pycel#NAME? |
financial-timevalue/9b2a4c |
=SYD(1000, 100, 10, 11) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice0 | formulas#NUM! | pycel#NAME? |
financial-timevalue/ab2df7 |
=XNPV(0.1, A1:A3, B1:B2) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#VALUE! | libreoffice#VALUE! | formulas-545.573 | pycel#NAME? |
info/c97757 |
=ISREF(42) |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformulafalse | libreofficefalse | formulasfalse | pycel#NAME? |
info/1121b3 |
=ISREF("A1") |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformulafalse | libreofficefalse | formulasfalse | pycel#NAME? |
lookup-longtail/4575b0 |
=ROWS(A1:A3) |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula3 | libreoffice3 | formulas3 | pycel#NAME? |
lookup-longtail/e34323 |
=ROWS(A1) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
lookup-longtail/39b86b |
=ROWS(B2:D10) |
9 | gsheets9 | excel9 | lattice9 | ironcalc9 | hyperformula9 | libreoffice9 | formulas9 | pycel#NAME? |
lookup-longtail/0feed3 |
=ROWS({1;2;3;4}) |
4 | gsheets4 | excel4 | lattice4 | ironcalc#VALUE! | hyperformula4 | libreoffice4 | formulas#VALUE! | pycel#NAME? |
lookup-longtail/3cf205 |
=ROWS({1,2;3,4;5,6}) |
3 | gsheets3 | excel3 | lattice3 | ironcalc#VALUE! | hyperformula3 | libreoffice3 | formulas#VALUE! | pycel#NAME? |
lookup-longtail/e14311 |
=COLUMNS(A1:C1) |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula3 | libreoffice3 | formulas3 | pycel#NAME? |
lookup-longtail/bc933c |
=COLUMNS(A1) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
lookup-longtail/1c6f2b |
=COLUMNS(B2:D10) |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula3 | libreoffice3 | formulas3 | pycel#NAME? |
lookup-longtail/82d96a |
=COLUMNS({1,2,3,4,5}) |
5 | gsheets5 | excel5 | lattice5 | ironcalc#VALUE! | hyperformula5 | libreoffice5 | formulas#VALUE! | pycel#NAME? |
lookup-longtail/11ac7b |
=COLUMNS({1,2;3,4;5,6}) |
2 | gsheets2 | excel2 | lattice2 | ironcalc#VALUE! | hyperformula2 | libreoffice2 | formulas#VALUE! | pycel#NAME? |
math-longtail/6fc8d4 |
=ISO.CEILING(4.3) |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula5 | libreoffice5 | formulas5 | pycel#NAME? |
math-longtail/7945d2 |
=ISO.CEILING(-4.3) |
-4 | gsheets-4 | excel-4 | lattice-4 | ironcalc-4 | hyperformula-4 | libreoffice-4 | formulas5 | pycel#NAME? |
math-longtail/e577b6 |
=ISO.CEILING(4.3, 2) |
6 | gsheets6 | excel6 | lattice6 | ironcalc6 | hyperformula6 | libreoffice6 | formulas6 | pycel#NAME? |
math-longtail/fae469 |
=ISO.CEILING(-4.3, -2) |
-4 | gsheets-4 | excel-4 | lattice-4 | ironcalc-4 | hyperformula-4 | libreoffice-4 | formulas-4 | pycel#NAME? |
math-longtail/4f03dc |
=GAMMALN(1) |
0 | gsheets0 | excel0 | lattice0 | ironcalc-4.441e-16 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
math-longtail/3eacb9 |
=GAMMALN(2) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula-4.441e-16 | libreoffice0 | formulas0 | pycel#NAME? |
math-longtail/69d257 |
=GAMMALN(0) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice#VALUE! | formulas#NUM! | pycel#NAME? |
math-longtail/bce0b4 |
=PRODUCT(2, 3, 4) |
24 | gsheets24 | excel24 | lattice24 | ironcalc24 | hyperformula24 | libreoffice24 | formulas24 | pycel#NAME? |
math-longtail/03c825 |
=PRODUCT(5, 0, 3) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
math-longtail/0e6191 |
=PRODUCT(7) |
7 | gsheets7 | excel7 | lattice7 | ironcalc7 | hyperformula7 | libreoffice7 | formulas7 | pycel#NAME? |
math-longtail/5078c2 |
=PRODUCT(A1:A3) |
24 | gsheets24 | excel24 | lattice24 | ironcalc24 | hyperformula24 | libreoffice24 | formulas24 | pycel#NAME? |
math-longtail/845f32 |
=SQRTPI(0) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
math-longtail/9f8138 |
=SQRTPI(-1) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice#VALUE! | formulas#NUM! | pycel#NAME? |
math/85eb30 |
=MROUND(10, 3) |
9 | gsheets9 | excel9 | lattice9 | ironcalc9 | hyperformula9 | libreoffice9 | formulas9 | pycel#NAME? |
math/12439b |
=SUMSQ(2) |
4 | gsheets4 | excel4 | lattice4 | ironcalc4 | hyperformula4 | libreoffice4 | formulas4 | pycel#NAME? |
math/c45ea8 |
=SUMSQ(1, 2) |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula5 | libreoffice5 | formulas5 | pycel#NAME? |
statistical-analytics/8feecc |
=CORREL(A1:A3, B1:B3) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
statistical-analytics/13052c |
=CORREL(A1:A3, B1:B3) |
-1 | gsheets-1 | excel-1 | lattice-1 | ironcalc-1 | hyperformula-1 | libreoffice-1 | formulas-1 | pycel#NAME? |
statistical-analytics/46788b |
=PEARSON(A1:A3, B1:B3) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
statistical-analytics/83b8c2 |
=RSQ(B1:B3, A1:A3) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
statistical-analytics/329591 |
=STEYX(B1:B4, A1:A4) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-analytics/98240f |
=SKEW(A1:A5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-descriptive/677838 |
=AVEDEV(A1:A5) |
1.2 | gsheets1.2 | excel1.2 | lattice1.2 | ironcalc1.2 | hyperformula1.2 | libreoffice1.2 | formulas1.2 | pycel#NAME? |
statistical-descriptive/d90cd6 |
=AVEDEV(1, 2, 3, 4, 5) |
1.2 | gsheets1.2 | excel1.2 | lattice1.2 | ironcalc1.2 | hyperformula1.2 | libreoffice1.2 | formulas1.2 | pycel#NAME? |
statistical-descriptive/7b6e94 |
=AVEDEV(7) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-descriptive/30b618 |
=AVEDEV(1, 3) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
statistical-descriptive/561510 |
=AVERAGEA(A1:A5) |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula3 | libreoffice3 | formulas3 | pycel#NAME? |
statistical-descriptive/f76912 |
=AVERAGEA(C1:C5) |
0.8 | gsheets0.8 | excel0.8 | lattice0.8 | ironcalc0.8 | hyperformula0.8 | libreoffice0.8 | formulas0.8 | pycel#NAME? |
statistical-descriptive/66c508 |
=AVERAGEA(1, "hello", 2) |
1 | gsheets#VALUE! | excel#VALUE! | lattice1 | ironcalc#VALUE! | hyperformula#VALUE! | libreoffice1 | formulas#VALUE! | pycel#NAME? |
statistical-descriptive/c0685f |
=COUNTA(C1:C5) |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula5 | libreoffice5 | formulas5 | pycel#NAME? |
statistical-descriptive/495afd |
=COUNTA(A1:A3) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula2 | libreoffice2 | formulas2 | pycel#NAME? |
statistical-descriptive/cd8f6b |
=COUNTA(1, "x", TRUE) |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula3 | libreoffice3 | formulas#VALUE! | pycel#NAME? |
statistical-descriptive/89c826 |
=DEVSQ(A1:A5) |
10 | gsheets10 | excel10 | lattice10 | ironcalc10 | hyperformula10 | libreoffice10 | formulas10 | pycel#NAME? |
statistical-descriptive/5dfa19 |
=DEVSQ(1, 2, 3, 4, 5) |
10 | gsheets10 | excel10 | lattice10 | ironcalc10 | hyperformula10 | libreoffice10 | formulas10 | pycel#NAME? |
statistical-descriptive/a7c259 |
=DEVSQ(7) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-descriptive/4fa5e7 |
=DEVSQ(2, 4) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula2 | libreoffice2 | formulas2 | pycel#NAME? |
statistical-descriptive/c1a95c |
=GEOMEAN(1, 1, 1) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
statistical-descriptive/3243f6 |
=GEOMEAN(2, 8) |
4 | gsheets4.00000 | excel4 | lattice4 | ironcalc4 | hyperformula4 | libreoffice4 | formulas4 | pycel#NAME? |
statistical-descriptive/493753 |
=GEOMEAN(0, 2, 4) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc0 | hyperformula#NUM! | libreoffice0 | formulas#NUM! | pycel#NAME? |
statistical-descriptive/4bda6d |
=HARMEAN(1, 1, 1) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
statistical-descriptive/931849 |
=HARMEAN(2, 6) |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula3 | libreoffice3 | formulas3 | pycel#NAME? |
statistical-descriptive/571170 |
=HARMEAN(0, 2, 4) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice#VALUE! | formulas#NUM! | pycel#NAME? |
statistical-descriptive/b47dcc |
=MAXA(A1:A5) |
5 | gsheets5 | excel5 | lattice5 | ironcalc5 | hyperformula5 | libreoffice5 | formulas5 | pycel#NAME? |
statistical-descriptive/59fc6a |
=MAXA(C1:C5) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula2 | libreoffice2 | formulas2 | pycel#NAME? |
statistical-descriptive/19e7f4 |
=MAXA(A1:A3) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-descriptive/db9d7d |
=MINA(A1:A5) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
statistical-descriptive/34a45e |
=MINA(C1:C5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-descriptive/5279f5 |
=MINA(A1:A3) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-descriptive/4f7c54 |
=MEDIAN(A1:A5) |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula3 | libreoffice3 | formulas3 | pycel#NAME? |
statistical-descriptive/3fca02 |
=MEDIAN(1, 2, 3, 4) |
2.5 | gsheets2.5 | excel2.5 | lattice2.5 | ironcalc2.5 | hyperformula2.5 | libreoffice2.5 | formulas2.5 | pycel#NAME? |
statistical-descriptive/725e84 |
=MEDIAN(7) |
7 | gsheets7 | excel7 | lattice7 | ironcalc7 | hyperformula7 | libreoffice7 | formulas7 | pycel#NAME? |
statistical-descriptive/fb2ef6 |
=MEDIAN(5, 1, 3, 2, 4) |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula3 | libreoffice3 | formulas3 | pycel#NAME? |
statistical-descriptive/c40ea3 |
=STANDARDIZE(10, 10, 2) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-descriptive/9981d6 |
=STANDARDIZE(12, 10, 2) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
statistical-descriptive/43e42c |
=STANDARDIZE(6, 10, 2) |
-2 | gsheets-2 | excel-2 | lattice-2 | ironcalc-2 | hyperformula-2 | libreoffice-2 | formulas-2 | pycel#NAME? |
statistical-descriptive/46bfe5 |
=STANDARDIZE(5, 10, 0) |
#NUM! | gsheets#NUM! | excel#NUM! | lattice#NUM! | ironcalc#NUM! | hyperformula#NUM! | libreoffice#DIV/0! | formulas#NUM! | pycel#NAME? |
statistical-descriptive/507d4d |
=VARA(A1:A5) |
2.5 | gsheets2.5 | excel2.5 | lattice2.5 | ironcalc2.5 | hyperformula2.5 | libreoffice2.5 | formulas2.5 | pycel#NAME? |
statistical-descriptive/d0a5b8 |
=VARPA(A1:A5) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula2 | libreoffice2 | formulas2 | pycel#NAME? |
statistical-distributions/e2c476 |
=FISHER(0) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-distributions/22f636 |
=FISHERINV(0) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula0 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-distributions/acd720 |
=FISHERINV(FISHER(0.75)) |
0.75 | gsheets0.75 | excel0.75 | lattice0.75 | ironcalc0.75 | hyperformula0.75 | libreoffice0.75 | formulas0.75 | pycel#NAME? |
statistical/4f7c54 |
=MEDIAN(1, 2, 3, 4, 5) |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula3 | libreoffice3 | formulas3 | pycel#NAME? |
statistical/3fca02 |
=MEDIAN(1, 2, 3, 4) |
2.5 | gsheets2.5 | excel2.5 | lattice2.5 | ironcalc2.5 | hyperformula2.5 | libreoffice2.5 | formulas2.5 | pycel#NAME? |
text-longtail/6faa52 |
=ROMAN(14) |
XIV | gsheetsXIV | excelXIV | latticeXIV | ironcalcXIV | hyperformulaXIV | libreofficeXIV | formulasXIV | pycel#NAME? |
text-longtail/252fcc |
=ROMAN(1994) |
MCMXCIV | gsheetsMCMXCIV | excelMCMXCIV | latticeMCMXCIV | ironcalcMCMXCIV | hyperformulaMCMXCIV | libreofficeMCMXCIV | formulasMCMXCIV | pycel#NAME? |
text-longtail/eccb3b |
=ROMAN(1) |
I | gsheetsI | excelI | latticeI | ironcalcI | hyperformulaI | libreofficeI | formulasI | pycel#NAME? |
text-longtail/aa8d16 |
=ROMAN(499, 0) |
CDXCIX | gsheetsCDXCIX | excelCDXCIX | latticeCDXCIX | ironcalcCDXCIX | hyperformulaCDXCIX | libreofficeCDXCIX | formulasCDXCIX | pycel#NAME? |
text-longtail/f87de8 |
=SEARCH("m", "Miriam McGovern") |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas1 | pycel#NAME? |
text-longtail/03dd2f |
=SEARCH("m", "Miriam McGovern", 3) |
5 | gsheets6 | excel6 | lattice6 | ironcalc6 | hyperformula6 | libreoffice6 | formulas6 | pycel#NAME? |
text-longtail/031624 |
=SEARCH("m?r", "Miriam McGovern") |
4 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas#VALUE! | pycel#NAME? |
text-longtail/b8b6d1 |
=SEARCH("M*n", "Miriam McGovern") |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula1 | libreoffice1 | formulas#VALUE! | pycel#NAME? |
text-longtail/3dabc9 |
=SEARCH("z", "Miriam McGovern") |
#VALUE! | gsheets#VALUE! | excel#VALUE! | lattice#VALUE! | ironcalc#VALUE! | hyperformula#VALUE! | libreoffice#VALUE! | formulas#VALUE! | pycel#NAME? |
text-longtail/9dcb5e |
=T("hello") |
hello | gsheetshello | excelhello | latticehello | ironcalchello | hyperformulahello | libreofficehello | formulashello | pycel#NAME? |
text-longtail/b07219 |
=T("42") |
42 | gsheets42 | excel42 | lattice42 | ironcalc42 | hyperformula42 | libreoffice42 | formulas42 | pycel#NAME? |
text-longtail/772f7c |
=T(42) |
gsheets— | excel— | lattice | ironcalc | hyperformula | libreoffice— | formulas— | pycel#NAME? | |
text-longtail/d3fea8 |
=T("") |
gsheets— | excel— | lattice | ironcalc | hyperformula | libreoffice— | formulas— | pycel#NAME? | |
text/4ccc5c |
=EXACT("word", "word") |
true | gsheetstrue | exceltrue | latticetrue | ironcalctrue | hyperformulatrue | libreofficetrue | formulastrue | pycel#NAME? |
text/d71904 |
=EXACT("Word", "word") |
false | gsheetsfalse | excelfalse | latticefalse | ironcalcfalse | hyperformulafalse | libreofficefalse | formulasfalse | pycel#NAME? |
text/b0c6a1 |
=REPT("ha", 3) |
hahaha | gsheetshahaha | excelhahaha | latticehahaha | ironcalchahaha | hyperformulahahaha | libreofficehahaha | formulashahaha | pycel#NAME? |