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 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
MDETERM/mdeterm-2x2-generic =MDETERM({1,2;3,4}) -2 gsheets-2 excel-2 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 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
MDETERM/mdeterm-singular =MDETERM({1,2;2,4}) 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0 pycel#NAME?
MINVERSE/minverse-2x2-identity =MINVERSE({1,0;0,1}) {1, 0; 0, 1} gsheets{1, 0; 0, 1} excel{1, 0; 0, 1} 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{-2.00000, 1; 1.50000, -0.500000} excel{-2.00000, 1; 1.50000, -0.500000} 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{2; 2; 1} excel{2; 2; 1} 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{3; 0} excel{3; 0} lattice{3; 0} ironcalc#NAME? hyperformula#NAME? libreoffice— formulas{3; 0} pycel#NAME?
FREQUENCY/frequency-single-bin =FREQUENCY(A1:A3, B1) {2; 1} gsheets{2; 1} excel{2; 1} 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 gsheets57.5 excel57.5 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 gsheets360 excel360 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 gsheets360 excel360 lattice360 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas360 pycel#NAME?
COUPDAYBS/coupdaybs-semiannual =COUPDAYBS(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 90 gsheets90 excel90 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 gsheets92 excel92 lattice92 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas92 pycel#NAME?
COUPDAYBS/coupdaybs-quarterly =COUPDAYBS(DATE(2011,2,15), DATE(2021,11,15), 4, 0) 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0 pycel#NAME?
COUPDAYS/coupdays-semiannual =COUPDAYS(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 180 gsheets180 excel180 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 gsheets181 excel181 lattice181 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas181 pycel#NAME?
COUPDAYS/coupdays-annual =COUPDAYS(DATE(2011,2,15), DATE(2021,11,15), 1, 0) 360 gsheets360 excel360 lattice360 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas360 pycel#NAME?
COUPDAYSNC/coupdaysnc-semiannual =COUPDAYSNC(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 90 gsheets90 excel90 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 gsheets89 excel89 lattice89 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas89 pycel#NAME?
COUPNCD/coupncd-semiannual =COUPNCD(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 40678 gsheets40678 excel40678 lattice40678 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas40678 pycel#NAME?
COUPNCD/coupncd-quarterly =COUPNCD(DATE(2011,2,15), DATE(2021,11,15), 4, 0) 40678 gsheets40678 excel40678 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 gsheets40862 excel40862 lattice40862 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas40862 pycel#NAME?
COUPNUM/coupnum-semiannual =COUPNUM(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 22 gsheets22 excel22 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 gsheets43 excel43 lattice43 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas43 pycel#NAME?
COUPPCD/couppcd-semiannual =COUPPCD(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 40497 gsheets40497 excel40497 lattice40497 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas40497 pycel#NAME?
COUPPCD/couppcd-quarterly =COUPPCD(DATE(2011,2,15), DATE(2021,11,15), 4, 0) 40589 gsheets40589 excel40589 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 gsheets40497 excel40497 lattice40497 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas40497 pycel#NAME?
VDB/vdb-first-year =VDB(2400, 300, 10, 0, 1) 480 gsheets480 excel480 lattice480 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas480 pycel#NAME?
PROB/prob-uniform-bound =PROB(A1:A5, B1:B5, 2, 4) 0.6 gsheets0.600000 excel0.600000 lattice0.600000 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.600000 pycel#NAME?
PROB/prob-single-upper =PROB(A1:A5, B1:B5, 3) 0.2 gsheets0.2 excel0.2 lattice0.2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.2 pycel#NAME?
PROB/prob-full-range =PROB(A1:A3, B1:B3, 1, 3) 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
MODE/mode-tied-dataset =MODE(B1:B5) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
MODE/mode-clear-winner =MODE(1, 2, 2, 3, 4) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
MODE/mode-no-repeats =MODE(1, 2, 3, 4, 5) #N/A gsheets#N/A excel#N/A 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 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
PERCENTILE/percentile-50th-on-1-5 =PERCENTILE(A1:A5, 0.5) 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
PERCENTILE/percentile-0th =PERCENTILE({1,2,3,4,5}, 0) 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
PERCENTILE/percentile-100th =PERCENTILE({1,2,3,4,5}, 1) 5 gsheets5 excel5 lattice5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas5 pycel#NAME?
PERCENTRANK/percentrank-midpoint =PERCENTRANK(A1:A5, 3) 0.5 gsheets0.5 excel0.5 lattice0.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.5 pycel#NAME?
PERCENTRANK/percentrank-minimum =PERCENTRANK(A1:A5, 1) 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0 pycel#NAME?
PERCENTRANK/percentrank-maximum =PERCENTRANK(A1:A5, 5) 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
PERMUT/permut-basic =PERMUT(5, 2) 20 gsheets20 excel20 lattice20 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas20 pycel#NAME?
PERMUT/permut-full =PERMUT(5, 5) 120 gsheets120 excel120 lattice120 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas120 pycel#NAME?
PERMUT/permut-zero =PERMUT(5, 0) 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
PERMUT/permut-invalid =PERMUT(3, 5) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?
QUARTILE/quartile-q1-on-1-5 =QUARTILE(A1:A5, 1) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
QUARTILE/quartile-q2-on-1-5 =QUARTILE(A1:A5, 2) 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
QUARTILE/quartile-q3-on-1-5 =QUARTILE(A1:A5, 3) 4 gsheets4 excel4 lattice4 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas4 pycel#NAME?
QUARTILE/quartile-invalid =QUARTILE({1,2,3,4,5}, 5) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?
RANK/rank-descending =RANK(20, A1:A4) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
RANK/rank-ascending =RANK(20, A1:A4, 1) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2 pycel#NAME?
RANK/rank-top-value =RANK(5, A1:A5) 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
RANK/rank-missing-value =RANK(5, A1:A3) #N/A gsheets#N/A excel#N/A 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 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
TRIMMEAN/trimmean-zero-percent =TRIMMEAN(A1:A5, 0) 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
TRIMMEAN/trimmean-skewed-dataset =TRIMMEAN({1,2,3,4,100}, 0.4) 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
TRIMMEAN/trimmean-invalid-percent =TRIMMEAN({1,2,3}, 1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NUM! pycel#NAME?
BINOMDIST/binomdist-pmf =BINOMDIST(2, 5, 0.5, FALSE) 0.3125 gsheets0.3125 excel0.3125 lattice0.3125 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.312500 pycel#NAME?
NORMDIST/normdist-at-mean-cdf =NORMDIST(0, 0, 1, TRUE) 0.5 gsheets0.5 excel0.5 lattice0.5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0.5 pycel#NAME?
ASC/asc-fullwidth-alpha =ASC("ABC") ABC gsheetsABC excelABC latticeABC ironcalc#NAME? hyperformula#NAME? libreoffice— formulasABC pycel#NAME?
ASC/asc-fullwidth-digits =ASC("123") 123 gsheets123 excel123 lattice123 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas123 pycel#NAME?
ASC/asc-ascii-passthrough =ASC("hello") hello gsheetshello excelhello latticehello ironcalc#NAME? hyperformula#NAME? libreoffice— formulashello pycel#NAME?
FINDB/findb-ascii =FINDB("world", "hello world") 7 gsheets7 excel7 lattice7 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas7 pycel#NAME?
FINDB/findb-at-start =FINDB("h", "hello") 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
FINDB/findb-not-found =FINDB("z", "hello") #VALUE! gsheets#VALUE! excel#VALUE! lattice#VALUE! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#VALUE! pycel#NAME?
FIXED/fixed-basic =FIXED(1234.567, 1) 1,234.6 gsheets1,234.6 excel1,234.6 lattice1,234.6 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1,234.6 pycel#NAME?
FIXED/fixed-no-commas =FIXED(1234.567, 1, TRUE) 1234.6 gsheets1234.6 excel1234.6 lattice1234.6 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1234.6 pycel#NAME?
FIXED/fixed-default =FIXED(1234.567) 1,234.57 gsheets1,234.57 excel1,234.57 lattice1,234.57 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1,234.57 pycel#NAME?
LEFTB/leftb-ascii =LEFTB("Sale Price", 4) Sale gsheetsSale excelSale latticeSale ironcalc#NAME? hyperformula#NAME? libreoffice— formulasSale pycel#NAME?
LEFTB/leftb-default =LEFTB("hello") h gsheetsh excelh latticeh ironcalc#NAME? hyperformula#NAME? libreoffice— formulash pycel#NAME?
LEFTB/leftb-zero =LEFTB("hello", 0) gsheets— excel— lattice ironcalc#NAME? hyperformula#NAME? libreoffice— formulas— pycel#NAME?
LENB/lenb-ascii =LENB("hello") 5 gsheets5 excel5 lattice5 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas5 pycel#NAME?
LENB/lenb-empty =LENB("") 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas0 pycel#NAME?
LENB/lenb-spaces =LENB(" ") 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas3 pycel#NAME?
MIDB/midb-ascii =MIDB("Romain", 3, 4) main gsheetsmain excelmain latticemain ironcalc#NAME? hyperformula#NAME? libreoffice— formulasmain pycel#NAME?
MIDB/midb-from-start =MIDB("Romain", 1, 2) Ro gsheetsRo excelRo latticeRo ironcalc#NAME? hyperformula#NAME? libreoffice— formulasRo pycel#NAME?
MIDB/midb-beyond-end =MIDB("Romain", 3, 100) main gsheetsmain excelmain latticemain ironcalc#NAME? hyperformula#NAME? libreoffice— formulasmain pycel#NAME?
REPLACEB/replaceb-ascii =REPLACEB("abcdefghijk", 6, 5, "*") abcde*k gsheetsabcde*k excelabcde*k latticeabcde*k ironcalc#NAME? hyperformula#NAME? libreoffice— formulasabcde*k pycel#NAME?
REPLACEB/replaceb-year =REPLACEB("2009", 3, 2, "10") 2010 gsheets2010 excel2010 lattice2010 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas2010 pycel#NAME?
REPLACEB/replaceb-empty-insert =REPLACEB("hello", 2, 3, "") ho gsheetsho excelho latticeho ironcalc#NAME? hyperformula#NAME? libreoffice— formulasho pycel#NAME?
RIGHTB/rightb-ascii =RIGHTB("Sale Price", 5) Price gsheetsPrice excelPrice latticePrice ironcalc#NAME? hyperformula#NAME? libreoffice— formulasPrice pycel#NAME?
RIGHTB/rightb-default =RIGHTB("hello") o gsheetso excelo latticeo ironcalc#NAME? hyperformula#NAME? libreoffice— formulaso pycel#NAME?
RIGHTB/rightb-zero =RIGHTB("hello", 0) gsheets— excel— lattice ironcalc#NAME? hyperformula#NAME? libreoffice— formulas— pycel#NAME?
SEARCHB/searchb-ascii =SEARCHB("m", "Miriam McGovern") 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas1 pycel#NAME?
SEARCHB/searchb-with-start =SEARCHB("M", "Miriam McGovern", 3) 8 gsheets6 excel6 lattice6 ironcalc#NAME? hyperformula#NAME? libreoffice— formulas6 pycel#NAME?
SEARCHB/searchb-not-found =SEARCHB("z", "Miriam") #VALUE! gsheets#VALUE! excel#VALUE! lattice#VALUE! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#VALUE! pycel#NAME?