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
array-longtail/a11b03 =MDETERM({1,0;0,1}) 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice1 formulas1 pycel#NAME?
array-longtail/58d004 =MDETERM({1,2;3,4}) -2 gsheets-2 excel-2 lattice-2 ironcalc#NAME? hyperformula#NAME? libreoffice-2 formulas-2 pycel#NAME?
array-longtail/4c549e =MDETERM({1,0,0;0,1,0;0,0,1}) 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice1 formulas1 pycel#NAME?
array-longtail/568f19 =MDETERM({1,2;2,4}) 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice0 formulas0 pycel#NAME?
array-longtail/f8a614 =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? libreoffice1 formulas[1, 0, 0, 1] pycel#NAME?
array-longtail/b633f1 =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-2 formulas[-2, 1, 1.5, -0.5] pycel#NAME?
array-longtail/659fda =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? libreoffice1 formulas[3×3] pycel#NAME?
array-longtail/ceb68a =FREQUENCY(A1:A5, B1:B2) [2, 2, 1] gsheets[2, 2, 1] excel[2, 2, 1] lattice[2, 2, 1] ironcalc#NAME? hyperformula#NAME? libreoffice2 formulas[2, 2, 1] pycel#NAME?
array-longtail/5272bd =FREQUENCY(A1:A3, B1) [3, 0] gsheets[3, 0] excel[3, 0] lattice[3, 0] ironcalc#NAME? hyperformula#NAME? libreoffice3 formulas[3, 0] pycel#NAME?
array-longtail/634b1b =FREQUENCY(A1:A3, B1) [2, 1] gsheets[2, 1] excel[2, 1] lattice[2, 1] ironcalc#NAME? hyperformula#NAME? libreoffice2 formulas[2, 1] pycel#NAME?
financial-securities/a9f519 =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? libreoffice57.5 formulas57.5 pycel#NAME?
financial-securities/f1902b =AMORLINC(2400, DATE(2008,8,19), DATE(2008,12,31), 300, 1, 0.15, 1) 360 gsheets360 excel360 lattice360 ironcalc#NAME? hyperformula#NAME? libreoffice360 formulas360 pycel#NAME?
financial-securities/897369 =AMORLINC(2400, DATE(2008,8,19), DATE(2008,12,31), 300, 1, 0.15, 0) 360 gsheets360 excel360 lattice360 ironcalc#NAME? hyperformula#NAME? libreoffice360 formulas360 pycel#NAME?
financial-securities/1a44d2 =COUPDAYBS(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 90 gsheets90 excel90 lattice90 ironcalc#NAME? hyperformula#NAME? libreoffice90 formulas90 pycel#NAME?
financial-securities/039474 =COUPDAYBS(DATE(2011,2,15), DATE(2021,11,15), 1, 1) 92 gsheets92 excel92 lattice92 ironcalc#NAME? hyperformula#NAME? libreoffice92 formulas92 pycel#NAME?
financial-securities/b66a95 =COUPDAYBS(DATE(2011,2,15), DATE(2021,11,15), 4, 0) 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice0 formulas0 pycel#NAME?
financial-securities/8307c3 =COUPDAYS(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 180 gsheets180 excel180 lattice180 ironcalc#NAME? hyperformula#NAME? libreoffice180 formulas180 pycel#NAME?
financial-securities/72ac0b =COUPDAYS(DATE(2011,2,15), DATE(2021,11,15), 2, 1) 181 gsheets181 excel181 lattice181 ironcalc#NAME? hyperformula#NAME? libreoffice181 formulas181 pycel#NAME?
financial-securities/b66641 =COUPDAYS(DATE(2011,2,15), DATE(2021,11,15), 1, 0) 360 gsheets360 excel360 lattice360 ironcalc#NAME? hyperformula#NAME? libreoffice360 formulas360 pycel#NAME?
financial-securities/d65c21 =COUPDAYSNC(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 90 gsheets90 excel90 lattice90 ironcalc#NAME? hyperformula#NAME? libreoffice90 formulas90 pycel#NAME?
financial-securities/0a32ce =COUPDAYSNC(DATE(2011,2,15), DATE(2021,11,15), 4, 1) 89 gsheets89 excel89 lattice89 ironcalc#NAME? hyperformula#NAME? libreoffice89 formulas89 pycel#NAME?
financial-securities/017d9a =COUPNCD(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 40678 gsheets40678 excel40678 lattice40678 ironcalc#NAME? hyperformula#NAME? libreoffice40678 formulas40678 pycel#NAME?
financial-securities/47f1ce =COUPNCD(DATE(2011,2,15), DATE(2021,11,15), 4, 0) 40678 gsheets40678 excel40678 lattice40678 ironcalc#NAME? hyperformula#NAME? libreoffice40678 formulas40678 pycel#NAME?
financial-securities/9a3186 =COUPNCD(DATE(2011,2,15), DATE(2021,11,15), 1, 1) 40862 gsheets40862 excel40862 lattice40862 ironcalc#NAME? hyperformula#NAME? libreoffice40862 formulas40862 pycel#NAME?
financial-securities/8cec31 =COUPNUM(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 22 gsheets22 excel22 lattice22 ironcalc#NAME? hyperformula#NAME? libreoffice22 formulas22 pycel#NAME?
financial-securities/0c2d18 =COUPNUM(DATE(2011,2,15), DATE(2021,11,15), 4, 1) 43 gsheets43 excel43 lattice43 ironcalc#NAME? hyperformula#NAME? libreoffice43 formulas43 pycel#NAME?
financial-securities/9467a0 =COUPPCD(DATE(2011,2,15), DATE(2021,11,15), 2, 0) 40497 gsheets40497 excel40497 lattice40497 ironcalc#NAME? hyperformula#NAME? libreoffice40497 formulas40497 pycel#NAME?
financial-securities/18bed1 =COUPPCD(DATE(2011,2,15), DATE(2021,11,15), 4, 0) 40589 gsheets40589 excel40589 lattice40589 ironcalc#NAME? hyperformula#NAME? libreoffice40589 formulas40589 pycel#NAME?
financial-securities/ea6233 =COUPPCD(DATE(2011,2,15), DATE(2021,11,15), 1, 1) 40497 gsheets40497 excel40497 lattice40497 ironcalc#NAME? hyperformula#NAME? libreoffice40497 formulas40497 pycel#NAME?
financial-timevalue/851e1c =VDB(2400, 300, 10, 0, 1) 480 gsheets480 excel480 lattice480 ironcalc#NAME? hyperformula#NAME? libreoffice480 formulas480 pycel#NAME?
statistical-analytics/9ece5c =PROB(A1:A5, B1:B5, 2, 4) 0.6 gsheets0.600000 excel0.600000 lattice0.600000 ironcalc#NAME? hyperformula#NAME? libreoffice0.6 formulas0.600000 pycel#NAME?
statistical-analytics/9f749c =PROB(A1:A5, B1:B5, 3) 0.2 gsheets0.2 excel0.2 lattice0.2 ironcalc#NAME? hyperformula#NAME? libreoffice0.2 formulas0.2 pycel#NAME?
statistical-analytics/c2533b =PROB(A1:A3, B1:B3, 1, 3) 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice1 formulas1 pycel#NAME?
statistical-descriptive/e925fa =MODE(B1:B5) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice2 formulas2 pycel#NAME?
statistical-descriptive/49de3f =MODE(1, 2, 2, 3, 4) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice2 formulas2 pycel#NAME?
statistical-descriptive/2901e2 =MODE(1, 2, 3, 4, 5) #N/A gsheets#N/A excel#N/A lattice#N/A ironcalc#NAME? hyperformula#NAME? libreoffice#VALUE! formulas#N/A pycel#NAME?
statistical-descriptive/e48203 =PERCENTILE(A1:A5, 0.25) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice2 formulas2 pycel#NAME?
statistical-descriptive/55fff9 =PERCENTILE(A1:A5, 0.5) 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice3 formulas3 pycel#NAME?
statistical-descriptive/d6bb83 =PERCENTILE({1,2,3,4,5}, 0) 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice1 formulas1 pycel#NAME?
statistical-descriptive/5f77f1 =PERCENTILE({1,2,3,4,5}, 1) 5 gsheets5 excel5 lattice5 ironcalc#NAME? hyperformula#NAME? libreoffice5 formulas5 pycel#NAME?
statistical-descriptive/2afe7a =PERCENTRANK(A1:A5, 3) 0.5 gsheets0.5 excel0.5 lattice0.5 ironcalc#NAME? hyperformula#NAME? libreoffice0.5 formulas0.5 pycel#NAME?
statistical-descriptive/44dc6c =PERCENTRANK(A1:A5, 1) 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice0 formulas0 pycel#NAME?
statistical-descriptive/9b0b3b =PERCENTRANK(A1:A5, 5) 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice1 formulas1 pycel#NAME?
statistical-descriptive/ff34c1 =PERMUT(5, 2) 20 gsheets20 excel20 lattice20 ironcalc#NAME? hyperformula#NAME? libreoffice20 formulas20 pycel#NAME?
statistical-descriptive/90763e =PERMUT(5, 5) 120 gsheets120 excel120 lattice120 ironcalc#NAME? hyperformula#NAME? libreoffice120 formulas120 pycel#NAME?
statistical-descriptive/e78c8d =PERMUT(5, 0) 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice1 formulas1 pycel#NAME?
statistical-descriptive/66de41 =PERMUT(3, 5) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice#VALUE! formulas#NUM! pycel#NAME?
statistical-descriptive/ea4957 =QUARTILE(A1:A5, 1) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice2 formulas2 pycel#NAME?
statistical-descriptive/fe31e2 =QUARTILE(A1:A5, 2) 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice3 formulas3 pycel#NAME?
statistical-descriptive/2b9567 =QUARTILE(A1:A5, 3) 4 gsheets4 excel4 lattice4 ironcalc#NAME? hyperformula#NAME? libreoffice4 formulas4 pycel#NAME?
statistical-descriptive/035450 =QUARTILE({1,2,3,4,5}, 5) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice#VALUE! formulas#NUM! pycel#NAME?
statistical-descriptive/9669eb =RANK(20, A1:A4) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice2 formulas2 pycel#NAME?
statistical-descriptive/50b24a =RANK(20, A1:A4, 1) 2 gsheets2 excel2 lattice2 ironcalc#NAME? hyperformula#NAME? libreoffice2 formulas2 pycel#NAME?
statistical-descriptive/f3f5c6 =RANK(5, A1:A5) 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice1 formulas1 pycel#NAME?
statistical-descriptive/38a306 =RANK(5, A1:A3) #N/A gsheets#N/A excel#N/A lattice#N/A ironcalc#NAME? hyperformula#NAME? libreoffice#N/A formulas#N/A pycel#NAME?
statistical-descriptive/95a64d =TRIMMEAN(A1:A5, 0.4) 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice3 formulas3 pycel#NAME?
statistical-descriptive/66f1cb =TRIMMEAN(A1:A5, 0) 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice3 formulas3 pycel#NAME?
statistical-descriptive/99fb7d =TRIMMEAN({1,2,3,4,100}, 0.4) 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice3 formulas3 pycel#NAME?
statistical-descriptive/585f54 =TRIMMEAN({1,2,3}, 1) #NUM! gsheets#NUM! excel#NUM! lattice#NUM! ironcalc#NAME? hyperformula#NAME? libreoffice#VALUE! formulas#NUM! pycel#NAME?
statistical-distributions/7ae66c =BINOMDIST(2, 5, 0.5, FALSE) 0.3125 gsheets0.3125 excel0.3125 lattice0.3125 ironcalc#NAME? hyperformula#NAME? libreoffice0.3125 formulas0.3125 pycel#NAME?
statistical-distributions/7169b0 =NORMDIST(0, 0, 1, TRUE) 0.5 gsheets0.5 excel0.5 lattice0.5 ironcalc#NAME? hyperformula#NAME? libreoffice0.5 formulas0.5 pycel#NAME?
text-longtail/128e5c =ASC("ABC") ABC gsheetsABC excelABC latticeABC ironcalc#NAME? hyperformula#NAME? libreofficeABC formulasABC pycel#NAME?
text-longtail/f47574 =ASC("123") 123 gsheets123 excel123 lattice123 ironcalc#NAME? hyperformula#NAME? libreoffice123 formulas123 pycel#NAME?
text-longtail/f29a28 =ASC("hello") hello gsheetshello excelhello latticehello ironcalc#NAME? hyperformula#NAME? libreofficehello formulashello pycel#NAME?
text-longtail/0dfc09 =FINDB("world", "hello world") 7 gsheets7 excel7 lattice7 ironcalc#NAME? hyperformula#NAME? libreoffice7 formulas7 pycel#NAME?
text-longtail/166848 =FINDB("h", "hello") 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice1 formulas1 pycel#NAME?
text-longtail/4d26db =FINDB("z", "hello") #VALUE! gsheets#VALUE! excel#VALUE! lattice#VALUE! ironcalc#NAME? hyperformula#NAME? libreoffice#VALUE! formulas#VALUE! pycel#NAME?
text-longtail/a8f34b =FIXED(1234.567, 1) 1,234.6 gsheets1,234.6 excel1,234.6 lattice1,234.6 ironcalc#NAME? hyperformula#NAME? libreoffice1,234.6 formulas1,234.6 pycel#NAME?
text-longtail/aa8b85 =FIXED(1234.567, 1, TRUE) 1234.6 gsheets1234.6 excel1234.6 lattice1234.6 ironcalc#NAME? hyperformula#NAME? libreoffice1234.6 formulas1234.6 pycel#NAME?
text-longtail/148445 =FIXED(1234.567) 1,234.57 gsheets1,234.57 excel1,234.57 lattice1,234.57 ironcalc#NAME? hyperformula#NAME? libreoffice1,234.57 formulas1,234.57 pycel#NAME?
text-longtail/ee2b6c =LEFTB("Sale Price", 4) Sale gsheetsSale excelSale latticeSale ironcalc#NAME? hyperformula#NAME? libreofficeSale formulasSale pycel#NAME?
text-longtail/dc5148 =LEFTB("hello") h gsheetsh excelh latticeh ironcalc#NAME? hyperformula#NAME? libreofficeh formulash pycel#NAME?
text-longtail/95e173 =LEFTB("hello", 0) gsheets— excel— lattice ironcalc#NAME? hyperformula#NAME? libreoffice— formulas— pycel#NAME?
text-longtail/514abe =LENB("hello") 5 gsheets5 excel5 lattice5 ironcalc#NAME? hyperformula#NAME? libreoffice5 formulas5 pycel#NAME?
text-longtail/b51361 =LENB("") 0 gsheets0 excel0 lattice0 ironcalc#NAME? hyperformula#NAME? libreoffice0 formulas0 pycel#NAME?
text-longtail/0fa999 =LENB(" ") 3 gsheets3 excel3 lattice3 ironcalc#NAME? hyperformula#NAME? libreoffice3 formulas3 pycel#NAME?
text-longtail/ca5d6b =MIDB("Romain", 3, 4) main gsheetsmain excelmain latticemain ironcalc#NAME? hyperformula#NAME? libreofficemain formulasmain pycel#NAME?
text-longtail/42207a =MIDB("Romain", 1, 2) Ro gsheetsRo excelRo latticeRo ironcalc#NAME? hyperformula#NAME? libreofficeRo formulasRo pycel#NAME?
text-longtail/a36817 =MIDB("Romain", 3, 100) main gsheetsmain excelmain latticemain ironcalc#NAME? hyperformula#NAME? libreofficemain formulasmain pycel#NAME?
text-longtail/0b43a2 =REPLACEB("abcdefghijk", 6, 5, "*") abcde*k gsheetsabcde*k excelabcde*k latticeabcde*k ironcalc#NAME? hyperformula#NAME? libreofficeabcde*k formulasabcde*k pycel#NAME?
text-longtail/cfb47c =REPLACEB("2009", 3, 2, "10") 2010 gsheets2010 excel2010 lattice2010 ironcalc#NAME? hyperformula#NAME? libreoffice2010 formulas2010 pycel#NAME?
text-longtail/129436 =REPLACEB("hello", 2, 3, "") ho gsheetsho excelho latticeho ironcalc#NAME? hyperformula#NAME? libreofficeho formulasho pycel#NAME?
text-longtail/eb6088 =RIGHTB("Sale Price", 5) Price gsheetsPrice excelPrice latticePrice ironcalc#NAME? hyperformula#NAME? libreofficePrice formulasPrice pycel#NAME?
text-longtail/74422a =RIGHTB("hello") o gsheetso excelo latticeo ironcalc#NAME? hyperformula#NAME? libreofficeo formulaso pycel#NAME?
text-longtail/faad2c =RIGHTB("hello", 0) gsheets— excel— lattice ironcalc#NAME? hyperformula#NAME? libreoffice— formulas— pycel#NAME?
text-longtail/76a2c0 =SEARCHB("m", "Miriam McGovern") 1 gsheets1 excel1 lattice1 ironcalc#NAME? hyperformula#NAME? libreoffice1 formulas1 pycel#NAME?
text-longtail/0c611f =SEARCHB("M", "Miriam McGovern", 3) 8 gsheets6 excel6 lattice6 ironcalc#NAME? hyperformula#NAME? libreoffice6 formulas6 pycel#NAME?
text-longtail/1e5af4 =SEARCHB("z", "Miriam") #VALUE! gsheets#VALUE! excel#VALUE! lattice#VALUE! ironcalc#NAME? hyperformula#NAME? libreoffice#VALUE! formulas#VALUE! pycel#NAME?