assay

DV-0001

pycel: function not implemented — AVEDEV, AVERAGEA, COLUMNS (+75 more)

Cause
missing-function
Category
value
Diverging engines
pycel
Behavior signature
{"error":"#NAME?"}
Test count
200
Seeded
2026-04-25
Last confirmed
2026-04-25

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
SUMX2MY2/sumx2my2-canonical =SUMX2MY2({1,2,3}, {4,5,6}) -63 gsheets-63 excel-63 lattice-63 ironcalc-63 hyperformula-63 libreoffice— formulas-63 pycel#NAME?
SUMX2MY2/sumx2my2-equal-arrays =SUMX2MY2({1,2,3}, {1,2,3}) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
SUMX2MY2/sumx2my2-singletons =SUMX2MY2({3}, {2}) 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula5 libreoffice— formulas5 pycel#NAME?
SUMX2PY2/sumx2py2-canonical =SUMX2PY2({1,2,3}, {4,5,6}) 91 gsheets91 excel91 lattice91 ironcalc91 hyperformula91 libreoffice— formulas91 pycel#NAME?
SUMX2PY2/sumx2py2-zeros =SUMX2PY2({0,0,0}, {0,0,0}) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
SUMX2PY2/sumx2py2-singleton =SUMX2PY2({3}, {4}) 25 gsheets25 excel25 lattice25 ironcalc25 hyperformula25 libreoffice— formulas25 pycel#NAME?
SUMXMY2/sumxmy2-canonical =SUMXMY2({1,2,3}, {4,5,6}) 27 gsheets27 excel27 lattice27 ironcalc27 hyperformula27 libreoffice— formulas27 pycel#NAME?
SUMXMY2/sumxmy2-equal-arrays =SUMXMY2({1,2,3}, {1,2,3}) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
SUMXMY2/sumxmy2-singletons =SUMXMY2({5}, {2}) 9 gsheets9 excel9 lattice9 ironcalc9 hyperformula9 libreoffice— formulas9 pycel#NAME?
DATEDIF/datedif-years =DATEDIF("2020-01-15", "2025-03-20", "Y") 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula#VALUE! libreoffice— formulas5 pycel#NAME?
DATEDIF/datedif-months =DATEDIF("2020-01-15", "2025-03-20", "M") 62 gsheets62 excel62 lattice62 ironcalc62 hyperformula#VALUE! libreoffice— formulas62 pycel#NAME?
DATEDIF/datedif-days =DATEDIF("2025-01-01", "2025-02-01", "D") 31 gsheets31 excel31 lattice31 ironcalc31 hyperformula#VALUE! libreoffice— formulas31 pycel#NAME?
DATEDIF/datedif-md-day-only =DATEDIF("2020-01-15", "2025-03-20", "MD") 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula#VALUE! libreoffice— formulas5 pycel#NAME?
DATEDIF/datedif-ym-month-only =DATEDIF("2020-01-15", "2025-03-20", "YM") 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#VALUE! libreoffice— formulas2 pycel#NAME?
DAYS360/days360-basic =DAYS360("2025-01-15", "2025-03-15") 60 gsheets60 excel60 lattice60 ironcalc60 hyperformula#VALUE! libreoffice— formulas60 pycel#NAME?
DAYS360/days360-full-year =DAYS360("2024-01-01", "2025-01-01") 360 gsheets360 excel360 lattice360 ironcalc360 hyperformula#VALUE! libreoffice— formulas360 pycel#NAME?
DAYS360/days360-european-method =DAYS360("2025-01-31", "2025-03-31", TRUE) 60 gsheets60 excel60 lattice60 ironcalc60 hyperformula#VALUE! libreoffice— formulas60 pycel#NAME?
HOUR/hour-from-time =HOUR(TIME(9, 15, 30)) 9 gsheets9 excel9 lattice9 ironcalc9 hyperformula9 libreoffice— formulas9 pycel#NAME?
MINUTE/minute-from-time =MINUTE(TIME(9, 15, 30)) 15 gsheets15 excel15 lattice15 ironcalc15 hyperformula15 libreoffice— formulas15 pycel#NAME?
NETWORKDAYS/networkdays-basic-week =NETWORKDAYS("2025-03-03", "2025-03-07") 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula#VALUE! libreoffice— formulas5 pycel#NAME?
NETWORKDAYS/networkdays-across-weekend =NETWORKDAYS("2025-03-07", "2025-03-10") 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#VALUE! libreoffice— formulas2 pycel#NAME?
NETWORKDAYS/networkdays-with-holiday =NETWORKDAYS("2025-03-03", "2025-03-07", "2025-03-05") 4 gsheets#VALUE! excel4 lattice4 ironcalc#VALUE! hyperformula#VALUE! libreoffice— formulas4 pycel#NAME?
NETWORKDAYS/networkdays-reversed =NETWORKDAYS("2025-03-07", "2025-03-03") -5 gsheets-5 excel-5 lattice-5 ironcalc-5 hyperformula#VALUE! libreoffice— formulas-5 pycel#NAME?
NETWORKDAYS.INTL/networkdays-intl-default-weekend =NETWORKDAYS.INTL("2025-03-03", "2025-03-07", 1) 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula#VALUE! libreoffice— formulas5 pycel#NAME?
NETWORKDAYS.INTL/networkdays-intl-numeric-weekend-sun-only =NETWORKDAYS.INTL("2025-03-03", "2025-03-09", 11) 6 gsheets6 excel6 lattice6 ironcalc6 hyperformula#VALUE! libreoffice— formulas6 pycel#NAME?
NETWORKDAYS.INTL/networkdays-intl-string-weekend-fri-sat =NETWORKDAYS.INTL("2025-03-03", "2025-03-09", "0000011") 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula#VALUE! libreoffice— formulas5 pycel#NAME?
NETWORKDAYS.INTL/networkdays-intl-string-weekend-custom =NETWORKDAYS.INTL("2025-03-03", "2025-03-09", "0000001") 6 gsheets6 excel6 lattice6 ironcalc6 hyperformula#VALUE! libreoffice— formulas6 pycel#NAME?
SECOND/second-from-time =SECOND(TIME(9, 15, 30)) 30 gsheets30 excel30 lattice30 ironcalc30 hyperformula30 libreoffice— formulas30 pycel#NAME?
TIME/time-midnight =TIME(0, 0, 0) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
WEEKNUM/weeknum-default =WEEKNUM("2025-01-05") 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#VALUE! libreoffice— formulas2 pycel#NAME?
WEEKNUM/weeknum-monday-start =WEEKNUM("2025-01-05", 2) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#VALUE! libreoffice— formulas1 pycel#NAME?
WORKDAY/workday-forward =WORKDAY("2025-03-03", 5) 45726 gsheets45726 excel45726 lattice45726 ironcalc45726 hyperformula#VALUE! libreoffice— formulas45726 pycel#NAME?
WORKDAY/workday-backward =WORKDAY("2025-03-10", -5) 45719 gsheets45719 excel45719 lattice45719 ironcalc45719 hyperformula#VALUE! libreoffice— formulas45719 pycel#NAME?
WORKDAY/workday-with-holiday =WORKDAY("2025-03-03", 5, "2025-03-05") 45727 gsheets#VALUE! excel45727 lattice45727 ironcalc#VALUE! hyperformula#VALUE! libreoffice— formulas45727 pycel#NAME?
WORKDAY/workday-zero-offset =WORKDAY("2025-03-03", 0) 45719 gsheets45719 excel45719 lattice45719 ironcalc45719 hyperformula#VALUE! libreoffice— formulas45719 pycel#NAME?
WORKDAY.INTL/workday-intl-default-weekend =WORKDAY.INTL("2025-03-03", 5, 1) 45726 gsheets45726 excel45726 lattice45726 ironcalc45726 hyperformula#VALUE! libreoffice— formulas45726 pycel#NAME?
WORKDAY.INTL/workday-intl-numeric-weekend-fri-sat =WORKDAY.INTL("2025-03-03", 5, 7) 45726 gsheets45726 excel45726 lattice45726 ironcalc45726 hyperformula#VALUE! libreoffice— formulas45726 pycel#NAME?
WORKDAY.INTL/workday-intl-string-weekend =WORKDAY.INTL("2025-03-03", 5, "0000011") 45726 gsheets45726 excel45726 lattice45726 ironcalc45726 hyperformula#VALUE! libreoffice— formulas45726 pycel#NAME?
WORKDAY.INTL/workday-intl-sunday-only-string =WORKDAY.INTL("2025-03-03", 5, "0000001") 45724 gsheets45724 excel45724 lattice45724 ironcalc45724 hyperformula#VALUE! libreoffice— formulas45724 pycel#NAME?
DELTA/delta-equal =DELTA(5, 5) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel#NAME?
DELTA/delta-not-equal =DELTA(5, 6) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
DELTA/delta-default-second-zero =DELTA(0) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel#NAME?
DELTA/delta-default-second-nonzero =DELTA(1) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
COMPLEX/complex-j-suffix =COMPLEX(3, 4, "j") 3+4j gsheets3+4j excel3+4j lattice3+4j ironcalc3+4j hyperformula3+4j libreoffice— formulas3+4j pycel#NAME?
IMABS/imabs-3-4-5-triangle =IMABS("3+4i") 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula5 libreoffice— formulas5 pycel#NAME?
IMABS/imabs-real-only =IMABS("5") 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula5 libreoffice— formulas5 pycel#NAME?
IMABS/imabs-imaginary-only =IMABS("4i") 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula4 libreoffice— formulas4 pycel#NAME?
IMAGINARY/imaginary-basic =IMAGINARY("3+4i") 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula4 libreoffice— formulas4 pycel#NAME?
IMAGINARY/imaginary-real-only =IMAGINARY("5") 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
IMAGINARY/imaginary-negative =IMAGINARY("3-4i") -4 gsheets-4 excel-4 lattice-4 ironcalc-4 hyperformula-4 libreoffice— formulas-4 pycel#NAME?
IMREAL/imreal-basic =IMREAL("3+4i") 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice— formulas3 pycel#NAME?
IMREAL/imreal-imaginary-only =IMREAL("4i") 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
IMREAL/imreal-negative =IMREAL("-3+4i") -3 gsheets-3 excel-3 lattice-3 ironcalc-3 hyperformula-3 libreoffice— formulas-3 pycel#NAME?
IMARGUMENT/imargument-real-positive =IMARGUMENT("1") 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
IMCONJUGATE/imconjugate-basic =IMCONJUGATE("3+4i") 3-4i gsheets3-4i excel3-4i lattice3-4i ironcalc3-4i hyperformula3-4i libreoffice— formulas3-4i pycel#NAME?
IMCONJUGATE/imconjugate-negative-imaginary =IMCONJUGATE("3-4i") 3+4i gsheets3+4i excel3+4i lattice3+4i ironcalc3+4i hyperformula3+4i libreoffice— formulas3+4i pycel#NAME?
IMCONJUGATE/imconjugate-real-only =IMCONJUGATE("5") 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula5 libreoffice— formulas5 pycel#NAME?
IMSUM/imsum-basic =IMSUM("1+2i", "3+4i") 4+6i gsheets4+6i excel4+6i lattice4+6i ironcalc4+6i hyperformula4+6i libreoffice— formulas4+6i pycel#NAME?
IMSUM/imsum-three-args =IMSUM("1+i", "2+2i", "3+3i") 6+6i gsheets6+6i excel6+6i lattice6+6i ironcalc#ERROR! hyperformula6+6i libreoffice— formulas6+6i pycel#NAME?
IMSUM/imsum-cancel-imaginary =IMSUM("1+2i", "1-2i") 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula2 libreoffice— formulas2 pycel#NAME?
IMSUB/imsub-basic =IMSUB("5+6i", "2+3i") 3+3i gsheets3+3i excel3+3i lattice3+3i ironcalc3+3i hyperformula3+3i libreoffice— formulas3+3i pycel#NAME?
IMSUB/imsub-to-zero =IMSUB("3+4i", "3+4i") 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
IMSUB/imsub-real-only =IMSUB("5", "2") 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice— formulas3 pycel#NAME?
IMPRODUCT/improduct-basic =IMPRODUCT("1+2i", "3+4i") -5+10i gsheets-5+10i excel-5+10i lattice-5+10i ironcalc-5+10i hyperformula-5+10i libreoffice— formulas-5+10i pycel#NAME?
IMPRODUCT/improduct-by-real =IMPRODUCT("3+4i", "2") 6+8i gsheets6+8i excel6+8i lattice6+8i ironcalc6+8i hyperformula6+8i libreoffice— formulas#VALUE! pycel#NAME?
IMPRODUCT/improduct-i-squared =IMPRODUCT("i", "i") -1 gsheets-1 excel-1 lattice-1 ironcalc-1 hyperformula-1 libreoffice— formulas-1 pycel#NAME?
IMDIV/imdiv-basic =IMDIV("-5+10i", "1+2i") 3+4i gsheets3+4i excel3+4i lattice3+4i ironcalc3+4i hyperformula3+4i libreoffice— formulas3+4i pycel#NAME?
IMDIV/imdiv-by-real =IMDIV("6+8i", "2") 3+4i gsheets3+4i excel3+4i lattice3+4i ironcalc3+4i hyperformula3+4i libreoffice— formulas#NUM! pycel#NAME?
DOLLARDE/dollarde-sixteenths =DOLLARDE(1.02, 16) 1.125 gsheets1.125 excel1.125 lattice1.125 ironcalc1.125 hyperformula1.125 libreoffice— formulas1.125 pycel#NAME?
DOLLARDE/dollarde-eighths =DOLLARDE(1.1, 8) 1.125 gsheets1.125 excel1.125 lattice1.125 ironcalc1.125 hyperformula1.125 libreoffice— formulas1.125 pycel#NAME?
DOLLARFR/dollarfr-sixteenths =DOLLARFR(1.125, 16) 1.02 gsheets1.02 excel1.02 lattice1.02 ironcalc1.02 hyperformula1.02 libreoffice— formulas1.02 pycel#NAME?
DOLLARFR/dollarfr-eighths =DOLLARFR(1.125, 8) 1.1 gsheets1.1 excel1.1 lattice1.1 ironcalc1.1 hyperformula1.1 libreoffice— formulas1.1 pycel#NAME?
DOLLARFR/dollarfr-thirty-twos =DOLLARFR(1.5, 32) 1.16 gsheets1.16 excel1.16 lattice1.16 ironcalc1.16 hyperformula1.16 libreoffice— formulas1.16 pycel#NAME?
TBILLPRICE/tbillprice-standard =TBILLPRICE(DATE(2008,3,31), DATE(2008,6,1), 0.09) 98.45 gsheets98.45 excel98.45 lattice98.45 ironcalc98.45 hyperformula98.45 libreoffice— formulas98.45 pycel#NAME?
CUMIPMT/cumipmt-invalid-period =CUMIPMT(0.05/12, 360, 100000, 0, 12, 0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
CUMPRINC/cumprinc-invalid-type =CUMPRINC(0.05/12, 360, 100000, 1, 12, 2) -1884.18 gsheets-1884.18 excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
DB/db-first-period =DB(1000000, 100000, 6, 1, 12) 319000 gsheets319000 excel319000 lattice319000 ironcalc319000 hyperformula319000 libreoffice— formulas319000 pycel#NAME?
DB/db-second-period =DB(1000000, 100000, 6, 2, 12) 217239 gsheets217239 excel217239 lattice217239 ironcalc217239 hyperformula217239 libreoffice— formulas217239 pycel#NAME?
DDB/ddb-period-1 =DDB(1000, 100, 10, 1) 200 gsheets200.000 excel200 lattice200 ironcalc200 hyperformula200 libreoffice— formulas200 pycel#NAME?
DDB/ddb-period-2 =DDB(1000, 100, 10, 2) 160 gsheets160.000 excel160 lattice160 ironcalc160 hyperformula160 libreoffice— formulas160.000 pycel#NAME?
DDB/ddb-custom-factor =DDB(2400, 300, 10, 1, 1.5) 360 gsheets360.000 excel360 lattice360 ironcalc360 hyperformula360 libreoffice— formulas360 pycel#NAME?
EFFECT/effect-monthly-compounding =EFFECT(0.12, 12) 0.126825 gsheets0.126825 excel0.126825 lattice0.126825 ironcalc0.12682503 hyperformula0.126825 libreoffice— formulas0.126825 pycel#NAME?
EFFECT/effect-annual-compounding =EFFECT(0.05, 1) 0.05 gsheets0.0500000 excel0.0500000 lattice0.0500000 ironcalc0.05 hyperformula0.05 libreoffice— formulas0.0500000 pycel#NAME?
EFFECT/effect-invalid-periods =EFFECT(0.05, 0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
FV/fv-annuity-10yr =FV(0.06, 10, -1000) 13180.79 gsheets13180.8 excel13180.8 lattice13180.8 ironcalc13180.79 hyperformula13180.794942 libreoffice— formulas13180.8 pycel#NAME?
FV/fv-lump-sum =FV(0.05, 20, 0, -10000) 26532.98 gsheets26533.0 excel26533.0 lattice26533.0 ironcalc26532.98 hyperformula26532.977051 libreoffice— formulas26533.0 pycel#NAME?
FV/fv-zero-rate =FV(0, 10, -100) 1000 gsheets1000 excel1000 lattice1000 ironcalc1000 hyperformula1000 libreoffice— formulas1000 pycel#NAME?
IPMT/ipmt-first-period-mortgage =IPMT(0.05/12, 1, 360, -200000) 833.333333 gsheets833.333 excel833.333 lattice833.333 ironcalc833.333 hyperformula833.33333333 libreoffice— formulas#NUM! pycel#NAME?
IPMT/ipmt-invalid-period =IPMT(0.05/12, 0, 360, -200000) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula834.3304699 libreoffice— formulas#NUM! pycel#NAME?
IRR/irr-no-sign-change =IRR(A1:A3) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
ISPMT/ispmt-first-period =ISPMT(0.05, 0, 5, -1000) 50 gsheets50 excel50 lattice50 ironcalc50 hyperformula50 libreoffice— formulas50 pycel#NAME?
ISPMT/ispmt-last-period =ISPMT(0.05, 5, 5, -1000) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
MIRR/mirr-no-sign-change =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— formulas#DIV/0! pycel#NAME?
NOMINAL/nominal-monthly =NOMINAL(0.126825030131969, 12) 0.12 gsheets0.120000 excel0.120000 lattice0.120000 ironcalc0.12 hyperformula0.12 libreoffice— formulas0.120000 pycel#NAME?
NOMINAL/nominal-annual =NOMINAL(0.05, 1) 0.05 gsheets0.0500000 excel0.0500000 lattice0.0500000 ironcalc0.05 hyperformula0.05 libreoffice— formulas0.0500000 pycel#NAME?
NOMINAL/nominal-invalid-rate =NOMINAL(-0.05, 4) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
NPER/nper-zero-rate =NPER(0, -100, 1000) 10 gsheets10 excel10 lattice10 ironcalc10 hyperformula10 libreoffice— formulas10 pycel#NAME?
NPER/nper-impossible =NPER(0.1, -1, 10000) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
PMT/pmt-monthly-mortgage =PMT(0.05/12, 360, -200000) 1073.64 gsheets1073.64 excel1073.64 lattice1073.64 ironcalc1073.64 hyperformula1073.643246 libreoffice— formulas1073.64 pycel#NAME?
PMT/pmt-zero-rate =PMT(0, 12, 12000) -1000 gsheets-1000 excel-1000 lattice-1000 ironcalc-1000 hyperformula-1000 libreoffice— formulas-1000 pycel#NAME?
PPMT/ppmt-ipmt-plus-ppmt-equals-pmt =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 libreoffice— formulas#NUM! pycel#NAME?
PPMT/ppmt-invalid-period =PPMT(0.05/12, 361, 360, -200000) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula1073.643246 libreoffice— formulas#NUM! pycel#NAME?
SLN/sln-textbook =SLN(1000, 100, 10) 90 gsheets90 excel90 lattice90 ironcalc90 hyperformula90 libreoffice— formulas90 pycel#NAME?
SLN/sln-no-salvage =SLN(5000, 0, 5) 1000 gsheets1000 excel1000 lattice1000 ironcalc1000 hyperformula1000 libreoffice— formulas1000 pycel#NAME?
SLN/sln-zero-life =SLN(1000, 100, 0) #DIV/0! gsheets#DIV/0! excel#DIV/0! lattice#DIV/0! ironcalc#DIV/0! hyperformula#DIV/0! libreoffice— formulas#DIV/0! pycel#NAME?
SYD/syd-period-1 =SYD(1000, 100, 10, 1) 163.636364 gsheets163.636 excel163.636 lattice163.636 ironcalc163.64 hyperformula163.63636364 libreoffice— formulas163.636 pycel#NAME?
SYD/syd-last-period =SYD(1000, 100, 10, 10) 16.363636 gsheets16.3636 excel16.3636 lattice16.3636 ironcalc16.36 hyperformula16.363636364 libreoffice— formulas16.3636 pycel#NAME?
SYD/syd-invalid-period =SYD(1000, 100, 10, 11) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
XNPV/xnpv-mismatched-lengths =XNPV(0.1, A1:A3, B1:B2) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#VALUE! libreoffice— formulas-545.573 pycel#NAME?
ISREF/isref-of-literal-number =ISREF(42) false gsheetsfalse excelfalse latticefalse ironcalcfalse hyperformulafalse libreoffice— formulasfalse pycel#NAME?
ISREF/isref-of-literal-text =ISREF("A1") false gsheetsfalse excelfalse latticefalse ironcalcfalse hyperformulafalse libreoffice— formulasfalse pycel#NAME?
ROWS/rows-3-row-range =ROWS(A1:A3) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice— formulas3 pycel#NAME?
ROWS/rows-single-cell =ROWS(A1) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel#NAME?
ROWS/rows-rectangular =ROWS(B2:D10) 9 gsheets9 excel9 lattice9 ironcalc9 hyperformula9 libreoffice— formulas9 pycel#NAME?
ROWS/rows-array-literal =ROWS({1;2;3;4}) 4 gsheets4 excel4 lattice4 ironcalc#VALUE! hyperformula4 libreoffice— formulas#VALUE! pycel#NAME?
ROWS/rows-2d-array-literal =ROWS({1,2;3,4;5,6}) 3 gsheets3 excel3 lattice3 ironcalc#VALUE! hyperformula3 libreoffice— formulas#VALUE! pycel#NAME?
COLUMNS/columns-3-col-range =COLUMNS(A1:C1) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice— formulas3 pycel#NAME?
COLUMNS/columns-single-cell =COLUMNS(A1) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel#NAME?
COLUMNS/columns-rectangular =COLUMNS(B2:D10) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice— formulas3 pycel#NAME?
COLUMNS/columns-array-literal =COLUMNS({1,2,3,4,5}) 5 gsheets5 excel5 lattice5 ironcalc#VALUE! hyperformula5 libreoffice— formulas#VALUE! pycel#NAME?
COLUMNS/columns-2d-array-literal =COLUMNS({1,2;3,4;5,6}) 2 gsheets2 excel2 lattice2 ironcalc#VALUE! hyperformula2 libreoffice— formulas#VALUE! pycel#NAME?
ISO.CEILING/iso-ceiling-positive =ISO.CEILING(4.3) 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula5 libreoffice— formulas5 pycel#NAME?
ISO.CEILING/iso-ceiling-negative =ISO.CEILING(-4.3) -4 gsheets-4 excel-4 lattice-4 ironcalc-4 hyperformula-4 libreoffice— formulas5 pycel#NAME?
ISO.CEILING/iso-ceiling-with-significance =ISO.CEILING(4.3, 2) 6 gsheets6 excel6 lattice6 ironcalc6 hyperformula6 libreoffice— formulas6 pycel#NAME?
ISO.CEILING/iso-ceiling-negative-significance-ignored =ISO.CEILING(-4.3, -2) -4 gsheets-4 excel-4 lattice-4 ironcalc-4 hyperformula-4 libreoffice— formulas-4 pycel#NAME?
GAMMALN/gammaln-at-1 =GAMMALN(1) 0 gsheets0 excel0 lattice0 ironcalc-4.441e-16 hyperformula0 libreoffice— formulas0 pycel#NAME?
GAMMALN/gammaln-at-2 =GAMMALN(2) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula-4.441e-16 libreoffice— formulas0 pycel#NAME?
GAMMALN/gammaln-non-positive =GAMMALN(0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
PRODUCT/product-scalars =PRODUCT(2, 3, 4) 24 gsheets24 excel24 lattice24 ironcalc24 hyperformula24 libreoffice— formulas24 pycel#NAME?
PRODUCT/product-with-zero =PRODUCT(5, 0, 3) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
PRODUCT/product-single =PRODUCT(7) 7 gsheets7 excel7 lattice7 ironcalc7 hyperformula7 libreoffice— formulas7 pycel#NAME?
PRODUCT/product-with-grid-range =PRODUCT(A1:A3) 24 gsheets24 excel24 lattice24 ironcalc24 hyperformula24 libreoffice— formulas24 pycel#NAME?
SQRTPI/sqrtpi-of-0 =SQRTPI(0) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
SQRTPI/sqrtpi-negative =SQRTPI(-1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
MROUND/mround-basic =MROUND(10, 3) 9 gsheets9 excel9 lattice9 ironcalc9 hyperformula9 libreoffice— formulas9 pycel#NAME?
SUMSQ/sumsq-single =SUMSQ(2) 4 gsheets4 excel4 lattice4 ironcalc4 hyperformula4 libreoffice— formulas4 pycel#NAME?
SUMSQ/sumsq-two-values =SUMSQ(1, 2) 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula5 libreoffice— formulas5 pycel#NAME?
CORREL/correl-perfect-positive =CORREL(A1:A3, B1:B3) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel#NAME?
CORREL/correl-perfect-negative =CORREL(A1:A3, B1:B3) -1 gsheets-1 excel-1 lattice-1 ironcalc-1 hyperformula-1 libreoffice— formulas-1 pycel#NAME?
PEARSON/pearson-perfect-positive =PEARSON(A1:A3, B1:B3) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel#NAME?
RSQ/rsq-perfect-fit =RSQ(B1:B3, A1:A3) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel#NAME?
STEYX/steyx-perfect-fit =STEYX(B1:B4, A1:A4) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
SKEW/skew-symmetric =SKEW(A1:A5) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
AVEDEV/avedev-whole-numbers =AVEDEV(A1:A5) 1.2 gsheets1.2 excel1.2 lattice1.2 ironcalc1.2 hyperformula1.2 libreoffice— formulas1.2 pycel#NAME?
AVEDEV/avedev-inline =AVEDEV(1, 2, 3, 4, 5) 1.2 gsheets1.2 excel1.2 lattice1.2 ironcalc1.2 hyperformula1.2 libreoffice— formulas1.2 pycel#NAME?
AVEDEV/avedev-single-value =AVEDEV(7) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
AVEDEV/avedev-two-values =AVEDEV(1, 3) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel#NAME?
AVERAGEA/averagea-whole-numbers =AVERAGEA(A1:A5) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice— formulas3 pycel#NAME?
AVERAGEA/averagea-mixed-types-coerce =AVERAGEA(C1:C5) 0.8 gsheets0.8 excel0.8 lattice0.8 ironcalc0.8 hyperformula0.8 libreoffice— formulas0.8 pycel#NAME?
AVERAGEA/averagea-text-literal =AVERAGEA(1, "hello", 2) 1 gsheets#VALUE! excel#VALUE! lattice1 ironcalc#VALUE! hyperformula#VALUE! libreoffice— formulas#VALUE! pycel#NAME?
COUNTA/counta-all-non-empty =COUNTA(C1:C5) 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula5 libreoffice— formulas5 pycel#NAME?
COUNTA/counta-with-empty-cell =COUNTA(A1:A3) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula2 libreoffice— formulas2 pycel#NAME?
COUNTA/counta-inline =COUNTA(1, "x", TRUE) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice— formulas#VALUE! pycel#NAME?
DEVSQ/devsq-whole-numbers =DEVSQ(A1:A5) 10 gsheets10 excel10 lattice10 ironcalc10 hyperformula10 libreoffice— formulas10 pycel#NAME?
DEVSQ/devsq-inline =DEVSQ(1, 2, 3, 4, 5) 10 gsheets10 excel10 lattice10 ironcalc10 hyperformula10 libreoffice— formulas10 pycel#NAME?
DEVSQ/devsq-single-value =DEVSQ(7) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
DEVSQ/devsq-two-values =DEVSQ(2, 4) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula2 libreoffice— formulas2 pycel#NAME?
GEOMEAN/geomean-of-1 =GEOMEAN(1, 1, 1) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel#NAME?
GEOMEAN/geomean-perfect-square =GEOMEAN(2, 8) 4 gsheets4.00000 excel4 lattice4 ironcalc4 hyperformula4 libreoffice— formulas4 pycel#NAME?
GEOMEAN/geomean-with-zero =GEOMEAN(0, 2, 4) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc0 hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
HARMEAN/harmean-all-ones =HARMEAN(1, 1, 1) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel#NAME?
HARMEAN/harmean-two-values =HARMEAN(2, 6) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice— formulas3 pycel#NAME?
HARMEAN/harmean-with-zero =HARMEAN(0, 2, 4) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
MAXA/maxa-whole-numbers =MAXA(A1:A5) 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula5 libreoffice— formulas5 pycel#NAME?
MAXA/maxa-mixed-types =MAXA(C1:C5) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula2 libreoffice— formulas2 pycel#NAME?
MAXA/maxa-negatives-with-text =MAXA(A1:A3) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
MINA/mina-whole-numbers =MINA(A1:A5) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel#NAME?
MINA/mina-mixed-types =MINA(C1:C5) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
MINA/mina-positives-with-text =MINA(A1:A3) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
MEDIAN/median-odd-count-statistical-descriptive =MEDIAN(A1:A5) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice— formulas3 pycel#NAME?
MEDIAN/median-even-count-statistical-descriptive =MEDIAN(1, 2, 3, 4) 2.5 gsheets2.5 excel2.5 lattice2.5 ironcalc2.5 hyperformula2.5 libreoffice— formulas2.5 pycel#NAME?
MEDIAN/median-single-value =MEDIAN(7) 7 gsheets7 excel7 lattice7 ironcalc7 hyperformula7 libreoffice— formulas7 pycel#NAME?
MEDIAN/median-unsorted =MEDIAN(5, 1, 3, 2, 4) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice— formulas3 pycel#NAME?
STANDARDIZE/standardize-at-mean =STANDARDIZE(10, 10, 2) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
STANDARDIZE/standardize-one-stdev-above =STANDARDIZE(12, 10, 2) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel#NAME?
STANDARDIZE/standardize-two-stdev-below =STANDARDIZE(6, 10, 2) -2 gsheets-2 excel-2 lattice-2 ironcalc-2 hyperformula-2 libreoffice— formulas-2 pycel#NAME?
STANDARDIZE/standardize-zero-stdev =STANDARDIZE(5, 10, 0) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NUM! hyperformula#NUM! libreoffice— formulas#NUM! pycel#NAME?
VARA/vara-numeric-only =VARA(A1:A5) 2.5 gsheets2.5 excel2.5 lattice2.5 ironcalc2.5 hyperformula2.5 libreoffice— formulas2.5 pycel#NAME?
VARPA/varpa-numeric-only =VARPA(A1:A5) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula2 libreoffice— formulas2 pycel#NAME?
FISHER/fisher-at-0 =FISHER(0) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
FISHERINV/fisherinv-at-0 =FISHERINV(0) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula0 libreoffice— formulas0 pycel#NAME?
FISHERINV/fisherinv-roundtrip =FISHERINV(FISHER(0.75)) 0.75 gsheets0.75 excel0.75 lattice0.75 ironcalc0.75 hyperformula0.75 libreoffice— formulas0.75 pycel#NAME?
MEDIAN/median-odd-count-statistical =MEDIAN(1, 2, 3, 4, 5) 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula3 libreoffice— formulas3 pycel#NAME?
MEDIAN/median-even-count-statistical =MEDIAN(1, 2, 3, 4) 2.5 gsheets2.5 excel2.5 lattice2.5 ironcalc2.5 hyperformula2.5 libreoffice— formulas2.5 pycel#NAME?
ROMAN/roman-14-xiv =ROMAN(14) XIV gsheetsXIV excelXIV latticeXIV ironcalcXIV hyperformulaXIV libreoffice— formulasXIV pycel#NAME?
ROMAN/roman-1994 =ROMAN(1994) MCMXCIV gsheetsMCMXCIV excelMCMXCIV latticeMCMXCIV ironcalcMCMXCIV hyperformulaMCMXCIV libreoffice— formulasMCMXCIV pycel#NAME?
ROMAN/roman-1 =ROMAN(1) I gsheetsI excelI latticeI ironcalcI hyperformulaI libreoffice— formulasI pycel#NAME?
ROMAN/roman-499-form0 =ROMAN(499, 0) CDXCIX gsheetsCDXCIX excelCDXCIX latticeCDXCIX ironcalcCDXCIX hyperformulaCDXCIX libreoffice— formulasCDXCIX pycel#NAME?
SEARCH/search-case-insensitive =SEARCH("m", "Miriam McGovern") 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas1 pycel#NAME?
SEARCH/search-with-start =SEARCH("m", "Miriam McGovern", 3) 5 gsheets6 excel6 lattice6 ironcalc6 hyperformula6 libreoffice— formulas6 pycel#NAME?
SEARCH/search-wildcard-question =SEARCH("m?r", "Miriam McGovern") 4 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas#VALUE! pycel#NAME?
SEARCH/search-wildcard-star =SEARCH("M*n", "Miriam McGovern") 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula1 libreoffice— formulas#VALUE! pycel#NAME?
SEARCH/search-not-found =SEARCH("z", "Miriam McGovern") #VALUE! gsheets#VALUE! excel#VALUE! lattice#VALUE! ironcalc#VALUE! hyperformula#VALUE! libreoffice— formulas#VALUE! pycel#NAME?
T/t-text-passthrough =T("hello") hello gsheetshello excelhello latticehello ironcalchello hyperformulahello libreoffice— formulashello pycel#NAME?
T/t-numeric-string-literal =T("42") 42 gsheets42 excel42 lattice42 ironcalc42 hyperformula42 libreoffice— formulas42 pycel#NAME?
T/t-number =T(42) gsheets— excel— lattice ironcalc hyperformula libreoffice— formulas— pycel#NAME?
T/t-empty =T("") gsheets— excel— lattice ironcalc hyperformula libreoffice— formulas— pycel#NAME?
EXACT/exact-match =EXACT("word", "word") true gsheetstrue exceltrue latticetrue ironcalctrue hyperformulatrue libreoffice— formulastrue pycel#NAME?
EXACT/exact-case-differs =EXACT("Word", "word") false gsheetsfalse excelfalse latticefalse ironcalcfalse hyperformulafalse libreoffice— formulasfalse pycel#NAME?
REPT/rept-basic =REPT("ha", 3) hahaha gsheetshahaha excelhahaha latticehahaha ironcalchahaha hyperformulahahaha libreoffice— formulashahaha pycel#NAME?