assay

DV-0003

hyperformula, ironcalc, pycel: function not implemented — ACCRINT, AMORLINC, ASC (+28 more)

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

Subjects (31)

ACCRINT AMORLINC ASC BINOMDIST COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD FINDB FIXED FREQUENCY LEFTB LENB MDETERM MIDB MINVERSE MODE NORMDIST PERCENTILE PERCENTRANK PERMUT PROB QUARTILE RANK REPLACEB RIGHTB SEARCHB TRIMMEAN VDB

Tests (88)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
MDETERM/mdeterm-2x2-identity =MDETERM({1,0;0,1}) 1 gsheets[object Object] excel[object Object] lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
MDETERM/mdeterm-2x2-generic =MDETERM({1,2;3,4}) -2 gsheets[object Object] excel[object Object] lattice-2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas-2 pycel#NAME?
MDETERM/mdeterm-3x3-identity =MDETERM({1,0,0;0,1,0;0,0,1}) 1 gsheets[object Object] excel[object Object] lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
MDETERM/mdeterm-singular =MDETERM({1,2;2,4}) 0 gsheets[object Object] excel[object Object] lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0 pycel#NAME?
MINVERSE/minverse-2x2-identity =MINVERSE({1,0;0,1}) {1, 0; 0, 1} gsheets{[object Object], [object Object]; [object Object], [object Object]} excel{[object Object], [object Object]; [object Object], [object Object]} lattice{1, 0; 0, 1} ironcalc#NAME? hyperformula#NAME? libreoffice— formulas{1, 0; 0, 1} pycel#NAME?
MINVERSE/minverse-2x2-generic =MINVERSE({1,2;3,4}) {-2, 1; 1.5, -0.5} gsheets{[object Object], [object Object]; [object Object], [object Object]} excel{[object Object], [object Object]; [object Object], [object Object]} lattice{-2.00000, 1; 1.50000, -0.500000} ironcalc#NAME? hyperformula#NAME? libreoffice— formulas{-2, 1; 1.5, -0.5} pycel#NAME?
MINVERSE/minverse-3x3-identity =MINVERSE({1,0,0;0,1,0;0,0,1}) [3×3] gsheets[3×3] excel[3×3] lattice[3×3] ironcalc#NAME? hyperformula#NAME? libreoffice— formulas[3×3] pycel#NAME?
FREQUENCY/frequency-basic-bins =FREQUENCY(A1:A5, B1:B2) {2; 2; 1} gsheets{[object Object]; [object Object]; [object Object]} excel{[object Object]; [object Object]; [object Object]} lattice{2; 2; 1} ironcalc#NAME? hyperformula#NAME? libreoffice— formulas{2; 2; 1} pycel#NAME?
FREQUENCY/frequency-all-below =FREQUENCY(A1:A3, B1) {3; 0} gsheets{[object Object]; [object Object]} excel{[object Object]; [object Object]} lattice{3; 0} ironcalc#NAME? hyperformula#NAME? libreoffice— formulas{3; 0} pycel#NAME?
FREQUENCY/frequency-single-bin =FREQUENCY(A1:A3, B1) {2; 1} gsheets{[object Object]; [object Object]} excel{[object Object]; [object Object]} lattice{2; 1} ironcalc#NAME? hyperformula#NAME? libreoffice— formulas{2; 1} pycel#NAME?
ACCRINT/accrint-quarterly =ACCRINT(DATE(2011,2,15), DATE(2011,5,15), DATE(2012,2,15), 0.0575, 1000, 4, 0) 57.5 gsheets[object Object] excel[object Object] lattice57.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas57.5 pycel#NAME?
AMORLINC/amorlinc-standard =AMORLINC(2400, DATE(2008,8,19), DATE(2008,12,31), 300, 1, 0.15, 1) 360 gsheets[object Object] excel[object Object] lattice360 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas360 pycel#NAME?
AMORLINC/amorlinc-basis-0 =AMORLINC(2400, DATE(2008,8,19), DATE(2008,12,31), 300, 1, 0.15, 0) 360 gsheets[object Object] excel[object Object] lattice360 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas360 pycel#NAME?
COUPDAYBS/coupdaybs-semiannual =COUPDAYBS(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 90 gsheets[object Object] excel[object Object] lattice90 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas90 pycel#NAME?
COUPDAYBS/coupdaybs-annual-basis-1 =COUPDAYBS(DATE(2011,2,15), DATE(2021,11,15), 1, 1) 92 gsheets[object Object] excel[object Object] lattice92 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas92 pycel#NAME?
COUPDAYBS/coupdaybs-quarterly =COUPDAYBS(DATE(2011,2,15), DATE(2021,11,15), 4, 0) 0 gsheets[object Object] excel[object Object] lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0 pycel#NAME?
COUPDAYS/coupdays-semiannual =COUPDAYS(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 180 gsheets[object Object] excel[object Object] lattice180 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas180 pycel#NAME?
COUPDAYS/coupdays-actual-basis-1 =COUPDAYS(DATE(2011,2,15), DATE(2021,11,15), 2, 1) 181 gsheets[object Object] excel[object Object] lattice181 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas181 pycel#NAME?
COUPDAYS/coupdays-annual =COUPDAYS(DATE(2011,2,15), DATE(2021,11,15), 1, 0) 360 gsheets[object Object] excel[object Object] lattice360 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas360 pycel#NAME?
COUPDAYSNC/coupdaysnc-semiannual =COUPDAYSNC(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 90 gsheets[object Object] excel[object Object] lattice90 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas90 pycel#NAME?
COUPDAYSNC/coupdaysnc-quarterly-basis-1 =COUPDAYSNC(DATE(2011,2,15), DATE(2021,11,15), 4, 1) 89 gsheets[object Object] excel[object Object] lattice89 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas89 pycel#NAME?
COUPNCD/coupncd-semiannual =COUPNCD(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 40678 gsheets[object Object] excel[object Object] lattice40678 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas40678 pycel#NAME?
COUPNCD/coupncd-quarterly =COUPNCD(DATE(2011,2,15), DATE(2021,11,15), 4, 0) 40678 gsheets[object Object] excel[object Object] lattice40678 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas40678 pycel#NAME?
COUPNCD/coupncd-annual-basis-1 =COUPNCD(DATE(2011,2,15), DATE(2021,11,15), 1, 1) 40862 gsheets[object Object] excel[object Object] lattice40862 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas40862 pycel#NAME?
COUPNUM/coupnum-semiannual =COUPNUM(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 22 gsheets[object Object] excel[object Object] lattice22 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas22 pycel#NAME?
COUPNUM/coupnum-quarterly-basis-1 =COUPNUM(DATE(2011,2,15), DATE(2021,11,15), 4, 1) 43 gsheets[object Object] excel[object Object] lattice43 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas43 pycel#NAME?
COUPPCD/couppcd-semiannual =COUPPCD(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 40497 gsheets[object Object] excel[object Object] lattice40497 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas40497 pycel#NAME?
COUPPCD/couppcd-quarterly =COUPPCD(DATE(2011,2,15), DATE(2021,11,15), 4, 0) 40589 gsheets[object Object] excel[object Object] lattice40589 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas40589 pycel#NAME?
COUPPCD/couppcd-annual-basis-1 =COUPPCD(DATE(2011,2,15), DATE(2021,11,15), 1, 1) 40497 gsheets[object Object] excel[object Object] lattice40497 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas40497 pycel#NAME?
VDB/vdb-first-year =VDB(2400, 300, 10, 0, 1) 480 gsheets[object Object] excel[object Object] lattice480 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas480 pycel#NAME?
PROB/prob-uniform-bound =PROB(A1:A5, B1:B5, 2, 4) 0.6 gsheets[object Object] excel[object Object] lattice0.600000 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.600000 pycel#NAME?
PROB/prob-single-upper =PROB(A1:A5, B1:B5, 3) 0.2 gsheets[object Object] excel[object Object] lattice0.2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.2 pycel#NAME?
PROB/prob-full-range =PROB(A1:A3, B1:B3, 1, 3) 1 gsheets[object Object] excel[object Object] lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
MODE/mode-tied-dataset =MODE(B1:B5) 2 gsheets[object Object] excel[object Object] lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
MODE/mode-clear-winner =MODE(1, 2, 2, 3, 4) 2 gsheets[object Object] excel[object Object] lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
MODE/mode-no-repeats =MODE(1, 2, 3, 4, 5) #N/A gsheets[object Object] excel[object Object] lattice#N/A ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#N/A pycel#NAME?
PERCENTILE/percentile-25th-on-1-5 =PERCENTILE(A1:A5, 0.25) 2 gsheets[object Object] excel[object Object] lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
PERCENTILE/percentile-50th-on-1-5 =PERCENTILE(A1:A5, 0.5) 3 gsheets[object Object] excel[object Object] lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
PERCENTILE/percentile-0th =PERCENTILE({1,2,3,4,5}, 0) 1 gsheets[object Object] excel[object Object] lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
PERCENTILE/percentile-100th =PERCENTILE({1,2,3,4,5}, 1) 5 gsheets[object Object] excel[object Object] lattice5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas5 pycel#NAME?
PERCENTRANK/percentrank-midpoint =PERCENTRANK(A1:A5, 3) 0.5 gsheets[object Object] excel[object Object] lattice0.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.5 pycel#NAME?
PERCENTRANK/percentrank-minimum =PERCENTRANK(A1:A5, 1) 0 gsheets[object Object] excel[object Object] lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0 pycel#NAME?
PERCENTRANK/percentrank-maximum =PERCENTRANK(A1:A5, 5) 1 gsheets[object Object] excel[object Object] lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
PERMUT/permut-basic =PERMUT(5, 2) 20 gsheets[object Object] excel[object Object] lattice20 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas20 pycel#NAME?
PERMUT/permut-full =PERMUT(5, 5) 120 gsheets[object Object] excel[object Object] lattice120 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas120 pycel#NAME?
PERMUT/permut-zero =PERMUT(5, 0) 1 gsheets[object Object] excel[object Object] lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
PERMUT/permut-invalid =PERMUT(3, 5) #NUM! gsheets[object Object] excel[object Object] lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?
QUARTILE/quartile-q1-on-1-5 =QUARTILE(A1:A5, 1) 2 gsheets[object Object] excel[object Object] lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
QUARTILE/quartile-q2-on-1-5 =QUARTILE(A1:A5, 2) 3 gsheets[object Object] excel[object Object] lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
QUARTILE/quartile-q3-on-1-5 =QUARTILE(A1:A5, 3) 4 gsheets[object Object] excel[object Object] lattice4 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas4 pycel#NAME?
QUARTILE/quartile-invalid =QUARTILE({1,2,3,4,5}, 5) #NUM! gsheets[object Object] excel[object Object] lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?
RANK/rank-descending =RANK(20, A1:A4) 2 gsheets[object Object] excel[object Object] lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
RANK/rank-ascending =RANK(20, A1:A4, 1) 2 gsheets[object Object] excel[object Object] lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
RANK/rank-top-value =RANK(5, A1:A5) 1 gsheets[object Object] excel[object Object] lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
RANK/rank-missing-value =RANK(5, A1:A3) #N/A gsheets[object Object] excel[object Object] lattice#N/A ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#N/A pycel#NAME?
TRIMMEAN/trimmean-40pct-on-1-5 =TRIMMEAN(A1:A5, 0.4) 3 gsheets[object Object] excel[object Object] lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
TRIMMEAN/trimmean-zero-percent =TRIMMEAN(A1:A5, 0) 3 gsheets[object Object] excel[object Object] lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
TRIMMEAN/trimmean-skewed-dataset =TRIMMEAN({1,2,3,4,100}, 0.4) 3 gsheets[object Object] excel[object Object] lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
TRIMMEAN/trimmean-invalid-percent =TRIMMEAN({1,2,3}, 1) #NUM! gsheets[object Object] excel[object Object] lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?
BINOMDIST/binomdist-pmf =BINOMDIST(2, 5, 0.5, FALSE) 0.3125 gsheets[object Object] excel[object Object] lattice0.3125 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.312500 pycel#NAME?
NORMDIST/normdist-at-mean-cdf =NORMDIST(0, 0, 1, TRUE) 0.5 gsheets[object Object] excel[object Object] lattice0.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.5 pycel#NAME?
ASC/asc-fullwidth-alpha =ASC("ABC") ABC gsheets[object Object] excel[object Object] latticeABC ironcalc#NAME? hyperformula#NAME? libreoffice— formulasABC pycel#NAME?
ASC/asc-fullwidth-digits =ASC("123") 123 gsheets[object Object] excel[object Object] lattice123 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas123 pycel#NAME?
ASC/asc-ascii-passthrough =ASC("hello") hello gsheets[object Object] excel[object Object] latticehello ironcalc#NAME? hyperformula#NAME? libreoffice— formulashello pycel#NAME?
FINDB/findb-ascii =FINDB("world", "hello world") 7 gsheets[object Object] excel[object Object] lattice7 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas7 pycel#NAME?
FINDB/findb-at-start =FINDB("h", "hello") 1 gsheets[object Object] excel[object Object] lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
FINDB/findb-not-found =FINDB("z", "hello") #VALUE! gsheets[object Object] excel[object Object] lattice#VALUE! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#VALUE! pycel#NAME?
FIXED/fixed-basic =FIXED(1234.567, 1) 1,234.6 gsheets[object Object] excel[object Object] lattice1,234.6 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1,234.6 pycel#NAME?
FIXED/fixed-no-commas =FIXED(1234.567, 1, TRUE) 1234.6 gsheets[object Object] excel[object Object] lattice1234.6 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1234.6 pycel#NAME?
FIXED/fixed-default =FIXED(1234.567) 1,234.57 gsheets[object Object] excel[object Object] lattice1,234.57 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1,234.57 pycel#NAME?
LEFTB/leftb-ascii =LEFTB("Sale Price", 4) Sale gsheets[object Object] excel[object Object] latticeSale ironcalc#NAME? hyperformula#NAME? libreoffice— formulasSale pycel#NAME?
LEFTB/leftb-default =LEFTB("hello") h gsheets[object Object] excel[object Object] latticeh ironcalc#NAME? hyperformula#NAME? libreoffice— formulash pycel#NAME?
LEFTB/leftb-zero =LEFTB("hello", 0) gsheets[object Object] excel[object Object] lattice— ironcalc— hyperformula— libreoffice— formulas— pycel—
LENB/lenb-ascii =LENB("hello") 5 gsheets[object Object] excel[object Object] lattice5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas5 pycel#NAME?
LENB/lenb-empty =LENB("") 0 gsheets[object Object] excel[object Object] lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0 pycel#NAME?
LENB/lenb-spaces =LENB(" ") 3 gsheets[object Object] excel[object Object] lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
MIDB/midb-ascii =MIDB("Romain", 3, 4) main gsheets[object Object] excel[object Object] latticemain ironcalc#NAME? hyperformula#NAME? libreoffice— formulasmain pycel#NAME?
MIDB/midb-from-start =MIDB("Romain", 1, 2) Ro gsheets[object Object] excel[object Object] latticeRo ironcalc#NAME? hyperformula#NAME? libreoffice— formulasRo pycel#NAME?
MIDB/midb-beyond-end =MIDB("Romain", 3, 100) main gsheets[object Object] excel[object Object] latticemain ironcalc#NAME? hyperformula#NAME? libreoffice— formulasmain pycel#NAME?
REPLACEB/replaceb-ascii =REPLACEB("abcdefghijk", 6, 5, "*") abcde*k gsheets[object Object] excel[object Object] latticeabcde*k ironcalc#NAME? hyperformula#NAME? libreoffice— formulasabcde*k pycel#NAME?
REPLACEB/replaceb-year =REPLACEB("2009", 3, 2, "10") 2010 gsheets[object Object] excel[object Object] lattice2010 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2010 pycel#NAME?
REPLACEB/replaceb-empty-insert =REPLACEB("hello", 2, 3, "") ho gsheets[object Object] excel[object Object] latticeho ironcalc#NAME? hyperformula#NAME? libreoffice— formulasho pycel#NAME?
RIGHTB/rightb-ascii =RIGHTB("Sale Price", 5) Price gsheets[object Object] excel[object Object] latticePrice ironcalc#NAME? hyperformula#NAME? libreoffice— formulasPrice pycel#NAME?
RIGHTB/rightb-default =RIGHTB("hello") o gsheets[object Object] excel[object Object] latticeo ironcalc#NAME? hyperformula#NAME? libreoffice— formulaso pycel#NAME?
RIGHTB/rightb-zero =RIGHTB("hello", 0) gsheets[object Object] excel[object Object] lattice— ironcalc— hyperformula— libreoffice— formulas— pycel—
SEARCHB/searchb-ascii =SEARCHB("m", "Miriam McGovern") 1 gsheets[object Object] excel[object Object] lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
SEARCHB/searchb-with-start =SEARCHB("M", "Miriam McGovern", 3) 8 gsheets[object Object] excel[object Object] lattice6 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas6 pycel#NAME?
SEARCHB/searchb-not-found =SEARCHB("z", "Miriam") #VALUE! gsheets[object Object] excel[object Object] lattice#VALUE! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#VALUE! pycel#NAME?