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