The catalogue
Functions and operators
Browse all 554 entries by category, or filter by name, description, localized name, function id or the state of our implementation. 554 entries = 531 functions + 23 operators = 534 published Excel rows + 7 split byte-variant rows + 13 added functions.
Compatibility
- BETADISTCumulative beta probability (the older form of BETA.DIST)Known larger differences on 166 of 336 recorded answers
- BETAINVInverse of the cumulative beta distribution (the older form of BETA.INV)Close: 46 of 68 recorded answers differ in the last bits, worst 12 ULP
- BINOMDISTBinomial probability (the older form of BINOM.DIST)Matches all 6 recorded answers
- CHIDISTRight-tail probability of the chi-squared distribution (older form)Known larger differences on 140 of 392 recorded answers
- CHIINVInverse of the right-tail chi-squared probability (older form)Known larger differences on 69 of 104 recorded answers
- CHITESTChi-squared test of independence (older form of CHISQ.TEST)Matches all 7 recorded answers
- CONCATENATETwo or more texts joined end to endKnown larger differences on 5 of 15 recorded answers
- CONFIDENCEHalf-width of a normal confidence interval for a mean (older form)Close: 2 of 5 recorded answers differ in the last bits, worst 2 ULP
- COVARPopulation covariance of two data sets (older form)Matches all 7 recorded answers
- CRITBINOMFewest successes whose cumulative binomial probability reaches a target (older form)Known larger differences on 1 of 1,269 recorded answers
- ECMA.CEILINGRounds a number up to a multiple, the form kept for ECMA-376 workbooksMatches all 6 recorded answers
- EXPONDISTExponential distribution (older form of EXPON.DIST)Matches all 9,745 recorded answers
- FDISTRight-tail probability of the F distribution (older form)Known larger differences on 3,760 of 4,404 recorded answers
- FINVInverse of the right-tail F probability (older form)Known larger differences on 32 of 37 recorded answers
- FLOORNumber rounded down, toward zero, to a multiple of the significanceKnown larger differences on 11 of 1,675 recorded answers
- FTESTTwo-tailed F-test probability (older form of F.TEST)Matches all 6 recorded answers
- GAMMADISTGamma distribution (older form of GAMMA.DIST)Close: 4 of 12 recorded answers differ in the last bits, worst 13 ULP
- GAMMAINVInverse of the cumulative gamma distribution (older form)Close: 2 of 5 recorded answers differ in the last bits, worst 2 ULP
- HYPGEOMDISTHypergeometric probability (older form)Close: 5 of 9 recorded answers differ in the last bits, worst 2 ULP
- JISText with half-width (single-byte) characters turned into their full-width formsNot implemented; recorded Windows Excel does not have it either
- LOGINVInverse of the cumulative lognormal distribution (older form)Close: 2 of 5 recorded answers differ in the last bits, worst 2 ULP
- LOGNORMDISTCumulative lognormal probability (older form)Close: 2,143 of 3,304 recorded answers differ in the last bits, worst 9 ULP
- MODEMost frequent number (older form)Matches all 24 recorded answers
- NEGBINOMDISTNegative binomial probability (older form)Known larger differences on 1,607 of 1,845 recorded answers
- NORMDISTNormal distribution (older form of NORM.DIST)Close: 383 of 4,516 recorded answers differ in the last bits, worst 5 ULP
- NORMINVInverse of the cumulative normal distribution (older form)Matches all 5 recorded answers
- NORMSDISTCumulative standard normal probability (older form)Matches all 3 recorded answers
- NORMSINVInverse of the cumulative standard normal distribution (older form)Matches all 3 recorded answers
- PERCENTILEValue at a given percentile, inclusive of 0 and 1 (older form)Matches all 6 recorded answers
- PERCENTRANKRelative standing of a value in a data set, as a fraction (older form)Matches all 66 recorded answers
- POISSONPoisson probability (older form of POISSON.DIST)Matches all 5 recorded answers
- QUARTILEA quartile of a data set, inclusive (older form)Matches all 5 recorded answers
- RANKRank of a number in a list (older form of RANK.EQ)Matches all 6 recorded answers
- STDEVSample standard deviation (older form)Matches all 1,304 recorded answers
- STDEVPPopulation standard deviation (older form)Matches all 1,266 recorded answers
- TDISTStudent's t probability, one- or two-tailed (older form)Known larger differences on 70 of 97 recorded answers
- TINVTwo-tailed inverse of Student's t distribution (older form)Known larger differences on 19 of 36 recorded answers
- TTESTStudent's t-test probability (older form of T.TEST)Close: 2 of 8 recorded answers differ in the last bits, worst 2 ULP
- VARSample variance (older form)Matches all 1,302 recorded answers
- VARPPopulation variance (older form)Matches all 1,302 recorded answers
- WEIBULLWeibull probability (older form of WEIBULL.DIST)Matches all 6 recorded answers
- ZTESTOne-tailed z-test probability (older form of Z.TEST)Close: 4 of 7 recorded answers differ in the last bits, worst 3 ULP
Cubes
- CUBEKPIMEMBERA key performance indicator property of an OLAP cubeNot yet implemented
- CUBEMEMBERA member or tuple of an OLAP cube, if it existsNot yet implemented
- CUBEMEMBERPROPERTYA property of a member of an OLAP cubeNot yet implemented
- CUBERANKEDMEMBERThe member at a given rank in a set from an OLAP cubeNot yet implemented
- CUBESETA set of members or tuples computed by an OLAP cube serverNot yet implemented
- CUBESETCOUNTHow many items a cube set holdsNot yet implemented
- CUBEVALUEAn aggregated value from an OLAP cubeNot yet implemented
Database functions
- DAVERAGEMean of a database column over the records that match the criteriaMatches all 3 recorded answers
- DCOUNTHow many numbers a database column holds in the records that match the criteriaMatches all 3 recorded answers
- DCOUNTAHow many non-empty entries a database column holds in the matching recordsMatches all 3 recorded answers
- DGETThe one value of a database column that matches the criteriaMatches all 3 recorded answers
- DMAXLargest value of a database column over the matching recordsMatches all 3 recorded answers
- DMINSmallest value of a database column over the matching recordsMatches all 3 recorded answers
- DPRODUCTProduct of a database column over the matching recordsMatches all 3 recorded answers
- DSTDEVSample standard deviation of a database column over the matching recordsMatches all 3 recorded answers
- DSTDEVPPopulation standard deviation of a database column over the matching recordsMatches all 3 recorded answers
- DSUMTotal of a database column over the matching recordsMatches all 3 recorded answers
- DVARSample variance of a database column over the matching recordsMatches all 3 recorded answers
- DVARPPopulation variance of a database column over the matching recordsMatches all 3 recorded answers
Date and time functions
- DATESerial date number for a year, month and dayMatches all 22,268 recorded answers
- DATEDIFWhole days, months or years between two datesMatches all 10 recorded answers
- DATEVALUESerial date number read from a date written as textMatches all 10 recorded answers
- DAYDay of the month (1 to 31) of a dateMatches all 10,158 recorded answers
- DAYSNumber of days from one date to anotherMatches all 9,572 recorded answers
- DAYS360Days between two dates counted with twelve 30-day monthsMatches all 4,571 recorded answers
- EDATEDate a number of months before or after a start dateMatches all 9,846 recorded answers
- EOMONTHLast day of the month a number of months before or after a dateMatches all 9,845 recorded answers
- HOURHour (0 to 23) of a timeMatches all 14,635 recorded answers
- ISOWEEKNUMISO 8601 week number of a dateMatches all 10,157 recorded answers
- MINUTEMinute (0 to 59) of a timeMatches all 14,635 recorded answers
- MONTHMonth (1 to 12) of a dateMatches all 10,157 recorded answers
- NETWORKDAYSWorking days between two dates, leaving out weekends and listed holidaysMatches all 3,616 recorded answers
- NETWORKDAYS.INTLWorking days between two dates with a chosen weekend and listed holidaysMatches all 3,621 recorded answers
- NOWCurrent date and time as a serial numberMatches all 2 recorded answers
- SECONDSecond (0 to 59) of a timeMatches all 14,635 recorded answers
- TIMETime serial (fraction of a day) for an hour, minute and secondMatches all 1,304 recorded answers
- TIMEVALUETime serial read from a time written as textMatches all 6 recorded answers
- TODAYCurrent date as a serial numberMatches all 2 recorded answers
- WEEKDAYDay of the week of a date, as a numberMatches all 19,534 recorded answers
- WEEKNUMWeek of the year a date falls inKnown larger differences on 443 of 13,339 recorded answers
- WORKDAYDate a number of working days before or after a start date, skipping weekends and holidaysMatches all 3,614 recorded answers
- WORKDAY.INTLDate a number of working days away, with a chosen weekend and listed holidaysMatches all 6,022 recorded answers
- YEARYear of a dateMatches all 10,167 recorded answers
- YEARFRACFraction of a year between two dates under a day-count basisMatches all 4,523 recorded answers
Engineering functions
- BESSELIModified Bessel function of the first kind, I_n(x)Matches all 1,462 recorded answers
- BESSELJBessel function of the first kind, J_n(x)Close: 1 of 1,240 recorded answers differ in the last bits, worst 1 ULP
- BESSELKModified Bessel function of the second kind, K_n(x)Matches all 1,325 recorded answers
- BESSELYBessel function of the second kind, Y_n(x)Known larger differences on 2 of 258 recorded answers
- BIN2DECDecimal value of a binary number given as textMatches all 316 recorded answers
- BIN2HEXBinary number rewritten in hexadecimalMatches all 752 recorded answers
- BIN2OCTBinary number rewritten in octalMatches all 746 recorded answers
- BITANDBits set in both of two whole numbersMatches all 5,993 recorded answers
- BITLSHIFTA whole number with its bits moved left by a given countMatches all 8,135 recorded answers
- BITORBits set in either of two whole numbersMatches all 5,993 recorded answers
- BITRSHIFTA whole number with its bits moved right by a given countMatches all 8,132 recorded answers
- BITXORBits set in exactly one of two whole numbersMatches all 5,993 recorded answers
- COMPLEXA complex number written as text from its real and imaginary partsKnown larger differences on 50 of 10,699 recorded answers
- CONVERTA measurement converted from one unit to anotherMatches all 33,977 recorded answers
- DEC2BINDecimal number written in binaryMatches all 4,811 recorded answers
- DEC2HEXDecimal number written in hexadecimalMatches all 4,811 recorded answers
- DEC2OCTDecimal number written in octalMatches all 4,811 recorded answers
- DELTA1 when two numbers are equal, otherwise 0Refuses 4 of 1,096 recorded calls; the rest match
- ERFError function, integrated between two limits or from 0Close: 2 of 4 recorded answers differ in the last bits, worst 1 ULP
- ERF.PRECISEError function integrated from 0 to xClose: 20 of 618,440 recorded answers differ in the last bits, worst 2 ULP
- ERFCComplementary error function, 1 - ERF(x)Close: 312 of 547 recorded answers differ in the last bits, worst 6 ULP
- ERFC.PRECISEComplementary error function integrated from x to infinityClose: 802 of 1,866 recorded answers differ in the last bits, worst 6 ULP
- GESTEP1 when a number is at least the step value, otherwise 0Refuses 4 of 1,100 recorded calls; the rest match
- HEX2BINHexadecimal number written in binaryMatches all 1,218 recorded answers
- HEX2DECDecimal value of a hexadecimal number given as textMatches all 1,028 recorded answers
- HEX2OCTHexadecimal number written in octalMatches all 1,222 recorded answers
- IMABSModulus (absolute value) of a complex numberMatches all 1,212 recorded answers
- IMAGINARYImaginary part of a complex numberMatches all 1,212 recorded answers
- IMARGUMENTArgument (angle in radians) of a complex numberMatches all 1,212 recorded answers
- IMCONJUGATEComplex conjugate of a complex numberMatches all 3,248 recorded answers
- IMCOSCosine of a complex numberMatches all 1,212 recorded answers
- IMCOSHHyperbolic cosine of a complex numberKnown larger differences on 7 of 1,212 recorded answers
- IMCOTCotangent of a complex numberMatches all 1,212 recorded answers
- IMCSCCosecant of a complex numberMatches all 1,212 recorded answers
- IMCSCHHyperbolic cosecant of a complex numberKnown larger differences on 8 of 1,212 recorded answers
- IMDIVQuotient of two complex numbersKnown larger differences on 1 of 2,071 recorded answers
- IMEXPe raised to a complex powerMatches all 3 recorded answers
- IMLNNatural logarithm of a complex numberMatches all 1,212 recorded answers
- IMLOG10Base-10 logarithm of a complex numberMatches all 1,212 recorded answers
- IMLOG2Base-2 logarithm of a complex numberMatches all 1,212 recorded answers
- IMPOWERA complex number raised to a real powerMatches all 4 recorded answers
- IMPRODUCTProduct of complex numbersMatches all 3,266 recorded answers
- IMREALReal part of a complex numberMatches all 1,212 recorded answers
- IMSECSecant of a complex numberMatches all 3 recorded answers
- IMSECHHyperbolic secant of a complex numberKnown larger differences on 4 of 1,212 recorded answers
- IMSINSine of a complex numberMatches all 1,212 recorded answers
- IMSINHHyperbolic sine of a complex numberKnown larger differences on 9 of 1,212 recorded answers
- IMSQRTPrincipal square root of a complex numberMatches all 2,032 recorded answers
- IMSUBOne complex number minus anotherMatches all 1,220 recorded answers
- IMSUMSum of complex numbersMatches all 3,266 recorded answers
- IMTANTangent of a complex numberMatches all 1,212 recorded answers
- OCT2BINOctal number written in binaryMatches all 1,205 recorded answers
- OCT2DECDecimal value of an octal number given as textMatches all 1,001 recorded answers
- OCT2HEXOctal number written in hexadecimalMatches all 1,202 recorded answers
External data functions
- IMPORTCSVLoads a CSV file into a refreshable arrayNeeds a host that can read files
- IMPORTTEXTLoads a delimited or fixed-width text file into a refreshable arrayNeeds a host that can read files
- PYRuns Python in Microsoft's cloud runtimeDeferred: needs an outside service
Financial functions
- ACCRINTInterest accrued on a security with periodic coupons, from issue to settlementMatches all 146,695 recorded answers
- ACCRINTMInterest accrued on a security that pays all its interest when it maturesMatches all 3,615 recorded answers
- AMORDEGRCFrench accounting depreciation for one period, with a coefficient that depends on the asset's lifeMatches all 46 recorded answers
- AMORLINCFrench accounting straight-line depreciation for one period, prorated in the first periodMatches all 127 recorded answers
- COUPDAYBSDays from the start of the coupon period to the settlement dateMatches all 5,610 recorded answers
- COUPDAYSDays in the coupon period that holds the settlement dateMatches all 5,591 recorded answers
- COUPDAYSNCDays left from settlement until the coupon date that follows itMatches all 5,591 recorded answers
- COUPNCDCoupon date that follows the settlement dateMatches all 5,591 recorded answers
- COUPNUMNumber of coupons still to be paid between settlement and maturityMatches all 5,597 recorded answers
- COUPPCDLast coupon date on or before the settlement dateMatches all 5,591 recorded answers
- CUMIPMTTotal interest paid on a loan between two periodsKnown larger differences on 77 of 276 recorded answers
- CUMPRINCPrincipal repaid on a loan from one period to another, added upKnown larger differences on 524 of 834 recorded answers
- DBFixed-declining-balance depreciation of an asset for one periodMatches all 2,045 recorded answers
- DDBDouble-declining-balance (or other factor) depreciation for one periodMatches all 1,770 recorded answers
- DISCYearly discount rate implied by a security's price and redemption valueMatches all 2,466 recorded answers
- DOLLARDEA price quoted as a fraction (such as 1.02 for 1 2/16) as a decimal numberMatches all 4,853 recorded answers
- DOLLARFRA decimal price written as a whole part and a fraction of a given denominatorMatches all 3,645 recorded answers
- DURATIONMacaulay duration of a security with periodic coupons, in yearsClose: 335 of 7,890 recorded answers differ in the last bits, worst 3 ULP
- EFFECTEffective annual rate from a nominal rate and the compounding periods per yearMatches all 2,588 recorded answers
- FVFuture value of an investment with fixed periodic payments and a fixed rateKnown larger differences on 2 of 2,567 recorded answers
- FVSCHEDULEFuture value of a principal grown by a series of interest ratesMatches all 6 recorded answers
- INTRATEInterest rate of a security bought and redeemed at given amountsMatches all 2,446 recorded answers
- IPMTInterest part of one payment on a loan or investmentKnown larger differences on 74 of 261 recorded answers
- IRRRate at which a series of periodic cash flows has a net present value of zeroKnown larger differences on 424 of 765 recorded answers
- ISPMTInterest paid in one period of a loan repaid in equal principal partsMatches all 6 recorded answers
- MDURATIONModified duration of a security with periodic couponsClose: 157 of 1,266 recorded answers differ in the last bits, worst 3 ULP
- MIRRInternal rate of return with separate finance and reinvestment ratesMatches all 6 recorded answers
- NOMINALNominal annual rate from an effective rate and the compounding periods per yearMatches all 2,094 recorded answers
- NPERNumber of periods needed to pay off a loan or reach a target valueMatches all 2,515 recorded answers
- NPVNet present value of periodic cash flows at a discount rateClose: 94 of 294 recorded answers differ in the last bits, worst 2 ULP
- ODDFPRICEPrice per 100 face value of a security whose first period is irregularMatches all 6 recorded answers
- ODDFYIELDYield of a security whose first period is irregularKnown larger differences on 44 of 92 recorded answers
- ODDLPRICEPrice per 100 face value of a security whose last period is irregularMatches all 6 recorded answers
- ODDLYIELDYield of a security whose last period is irregularMatches all 6 recorded answers
- PDURATIONNumber of periods an investment needs to grow to a target value at a fixed rateMatches all 1,210 recorded answers
- PMTFixed payment per period that pays off a loan at a fixed rateClose: 151 of 291,987 recorded answers differ in the last bits, worst 4 ULP
- PPMTPrincipal part of one payment on a loan or investmentKnown larger differences on 59 of 237 recorded answers
- PRICEPrice per 100 face value of a security with periodic couponsClose: 50 of 9,160 recorded answers differ in the last bits, worst 1 ULP
- PRICEDISCPrice, per 100 of face value, of a security sold at a discountMatches all 2,446 recorded answers
- PRICEMATPrice, per 100 of face value, of a security whose interest is all paid at maturityMatches all 3,614 recorded answers
- PVPresent value of an investment with fixed periodic payments and a fixed rateKnown larger differences on 162 of 1,314 recorded answers
- RATEInterest rate per period that makes the payments match the present and future valuesKnown larger differences on 416 of 470 recorded answers
- RECEIVEDRedemption amount of a security bought at a price and held to maturity at a discount rateMatches all 2,446 recorded answers
- RRIEquivalent rate per period for an investment to grow from a present to a future valueRefuses 45 of 5,533 recorded calls; the rest match
- SLNDepreciation per period by the straight-line methodMatches all 1,211 recorded answers
- SYDSum-of-years'-digits depreciation for one periodMatches all 1,213 recorded answers
- TBILLEQTreasury bill yield restated as a bond-equivalent yieldMatches all 3,611 recorded answers
- TBILLPRICETreasury bill price per 100 of face value, from its discount rateMatches all 3,611 recorded answers
- TBILLYIELDTreasury bill yield, from its priceMatches all 2,411 recorded answers
- VDBDeclining-balance depreciation over any span of periods, with an optional switch to straight lineMatches all 2,210 recorded answers
- XIRRRate at which cash flows on given dates have a net present value of zeroMatches all 7 recorded answers
- XNPVNet present value of cash flows on given datesMatches all 3,414 recorded answers
- YIELDYield of a security with periodic couponsKnown larger differences on 561 of 625 recorded answers
- YIELDDISCAnnual yield of a discounted securityMatches all 31 recorded answers
- YIELDMATYearly yield of a security whose interest is all paid at maturityMatches all 1,091 recorded answers
Information functions
- CELLA fact about a cell, such as its address, format, contents or widthMatches all 771 recorded answers
- ERROR.TYPENumber identifying which error value a cell holdsMatches all 1,268 recorded answers
- INFOA fact about the environment Excel runs in, such as the version or the systemMatches all 21 recorded answers
- ISBLANKTRUE when the cell is emptyMatches all 1,585 recorded answers
- ISERRTRUE for any error value other than #N/AMatches all 1,248 recorded answers
- ISERRORTRUE for any error valueMatches all 1,249 recorded answers
- ISEVENTRUE when the whole part of a number is evenRefuses 2 of 57,224 recorded calls; the rest match
- ISFORMULATRUE when the cell holds a formulaMatches all 16 recorded answers
- ISLOGICALTRUE when the value is TRUE or FALSEMatches all 1,238 recorded answers
- ISNATRUE when the value is #N/AMatches all 1,240 recorded answers
- ISNONTEXTTRUE when the value is anything but textMatches all 1,237 recorded answers
- ISNUMBERTRUE when the value is a numberMatches all 1,256 recorded answers
- ISODDTRUE when the whole part of a number is oddRefuses 2 of 57,163 recorded calls; the rest match
- ISOMITTEDTRUE when a LAMBDA parameter was left out of the callMatches all 5 recorded answers
- ISREFTRUE when the value is a referenceMatches all 1,252 recorded answers
- ISTEXTTRUE when the value is textMatches all 1,240 recorded answers
- NA value as a number: numbers as they are, dates as serials, TRUE as 1, everything else 0Refuses 3 of 1,385 recorded calls; the rest match
- NAThe error value #N/AMatches all 4 recorded answers
- SHEETNumber of the sheet a reference or name points toMatches all 5 recorded answers
- SHEETSNumber of sheets in a reference or in the workbookMatches all 6 recorded answers
- STOCKHISTORYHistorical prices of a financial instrument over a date rangeDeferred: needs an outside service
- TYPENumber saying what kind of value an argument isMatches all 1,582 recorded answers
Logical functions
- ANDTRUE only when every argument is TRUEMatches all 1,264 recorded answers
- BYCOLOne result per column, from a LAMBDA called on each columnMatches all 32 recorded answers
- BYROWOne result per row, from a LAMBDA called on each rowMatches all 27 recorded answers
- FALSEThe logical value FALSEMatches all 4 recorded answers
- IFERRORThe value of an expression, or a fallback when it is an errorMatches all 95 recorded answers
- IFNAThe value of an expression, or a fallback when it is #N/AMatches all 36 recorded answers
- IFSThe value paired with the first condition that is TRUEMatches all 1,254 recorded answers
- LAMBDAA function defined in the formula from parameters and a calculationMatches all 28 recorded answers
- MAKEARRAYAn array of a given size whose items a LAMBDA computes from row and columnMatches all 11 recorded answers
- MAPAn array of the results of a LAMBDA applied to each item of the given arraysMatches all 35 recorded answers
- NOTThe opposite logical valueRefuses 2 of 1,377 recorded calls; the rest match
- ORTRUE when at least one argument is TRUEMatches all 1,247 recorded answers
- REDUCEA running total built by a LAMBDA over each item of an array, giving the final valueMatches all 16 recorded answers
- SCANEvery intermediate value of a running calculation by a LAMBDA over an arrayMatches all 21 recorded answers
- SWITCHThe result paired with the first value that equals the expression, or a defaultKnown larger differences on 4 of 1,395 recorded answers
- TRUEThe logical value TRUEMatches all 4 recorded answers
- XORTRUE when an odd number of the arguments are TRUEMatches all 1,237 recorded answers
Lookup and reference functions
- ADDRESSText of a cell reference built from a row and a column numberMatches all 1,304 recorded answers
- AREASHow many separate areas a reference coversMatches all 11 recorded answers
- CHOOSEThe value at a given position in a list of argumentsMatches all 40 recorded answers
- CHOOSECOLSSelected columns of an array, in the order asked forMatches all 17 recorded answers
- CHOOSEROWSSelected rows of an array, in the order asked forMatches all 16 recorded answers
- COLUMNColumn number of the first cell of a reference (of the formula's cell when left out)Matches all 9 recorded answers
- COLUMNSHow many columns an array or reference hasKnown larger differences on 22 of 932 recorded answers
- DROPAn array with a number of rows or columns removed from its start or endMatches all 17 recorded answers
- EXPANDAn array padded out to a given number of rows and columnsMatches all 23 recorded answers
- FIELDVALUEA named field of a linked data typeMatches all 25 recorded answers
- FLATTENRemoves nesting layers from an arrayNot yet implemented
- FORMULATEXTThe formula of a cell, as textMatches all 4 recorded answers
- GETPIVOTDATAA value read out of a PivotTable reportRefuses all 2 recorded calls
- GROUPBYA summary table with values aggregated by the groups of one or more row fieldsMatches all 428 recorded answers
- HASWhether a value appears in an arrayNot yet implemented
- HASALLWhether all of the values appear in an arrayNot yet implemented
- HASANYWhether any of the values appear in an arrayNot yet implemented
- HLOOKUPA value from a given row of a table, in the column found by searching the top rowMatches all 30 recorded answers
- HSTACKArrays placed side by side into one arrayKnown larger differences on 5 of 28 recorded answers
- HYPERLINKA clickable link to a document or web address, shown with a labelMatches all 3 recorded answers
- IMAGEA picture from a web address shown inside the cellNot yet implemented
- INDEXThe value or reference at a given row and column of an array or rangeKnown larger differences on 264 of 12,437 recorded answers
- INDIRECTThe reference that a text namesMatches all 174 recorded answers
- LOOKUPA value found by searching one row or column, taken from the matching place in anotherMatches all 38 recorded answers
- MATCHPosition of a value within a row or columnMatches all 156 recorded answers
- OFFSETA reference shifted by rows and columns from a start, optionally resizedMatches all 7 recorded answers
- PIVOTBYA cross-tab of values aggregated by row groups and column groupsMatches all 1,454 recorded answers
- ROWRow number of the first cell of a reference (of the formula's cell when left out)Matches all 11 recorded answers
- ROWSHow many rows an array or reference hasKnown larger differences on 22 of 975 recorded answers
- RTDLive data from a program that supports real-time data (COM automation)Needs a real-time data server
- SORTThe contents of an array in sorted orderKnown larger differences on 20 of 93 recorded answers
- SORTBYAn array sorted by the values of other arraysMatches all 14 recorded answers
- TAKERows or columns kept from the start or end of an arrayMatches all 10 recorded answers
- TOCOLThe items of an array in one columnMatches all 9 recorded answers
- TOROWThe items of an array in one rowMatches all 9 recorded answers
- TRANSPOSEAn array with rows and columns swappedMatches all 7 recorded answers
- TRIMRANGEA range with its empty outer rows and columns cut awayMatches all 2 recorded answers
- VLOOKUPA value from a given column of a table, in the row found by searching the first columnMatches all 63 recorded answers
- VSTACKArrays placed one above another into one arrayMatches all 12 recorded answers
- WRAPCOLSA row or column of values folded into columns of a given lengthMatches all 15 recorded answers
- WRAPROWSA row or column of values folded into rows of a given lengthMatches all 7 recorded answers
- XMATCHPosition of a value in an array, with match and search optionsMatches all 251 recorded answers
Math and trigonometry functions
- ABSAbsolute value: the number without its sign, its distance from zeroRefuses 2 of 1,383 recorded calls; the rest match
- ACOSAngle in radians, from 0 to pi, whose cosine is the given numberMatches all 13,965 recorded answers
- ACOSHInverse of the hyperbolic cosineMatches all 5,733 recorded answers
- ACOTAngle in radians, from 0 to pi, whose cotangent is the given numberMatches all 16,927 recorded answers
- ACOTHInverse of the hyperbolic cotangentMatches all 269,999 recorded answers
- AGGREGATEOne of nineteen summaries (sum, average, percentile and more) of a range, optionally skipping errors, hidden rows and nested subtotalsMatches all 8 recorded answers
- ARABICNumber written by a Roman numeralMatches all 3 recorded answers
- ASINAngle in radians, from -pi/2 to pi/2, whose sine is the given numberMatches all 21,613 recorded answers
- ASINHInverse of the hyperbolic sineMatches all 4,537 recorded answers
- ATANAngle in radians, between -pi/2 and pi/2, whose tangent is the given numberMatches all 181,412 recorded answers
- ATAN2Angle in radians from the positive x-axis to the point (x, y), between -pi and piMatches all 124 recorded answers
- ATANHInverse of the hyperbolic tangentMatches all 22,011 recorded answers
- BASEA number written as text in another base (radix 2 to 36)Matches all 3,565 recorded answers
- CEILINGNumber rounded up, away from zero, to a multiple of the significanceKnown larger differences on 12 of 1,672 recorded answers
- CEILING.MATHNumber rounded up to a multiple of the significance, with a choice of direction for negative numbersRefuses 12 of 1,486 recorded calls; the rest match
- CEILING.PRECISENumber rounded up toward plus infinity to a multiple of the significance, whatever its signKnown larger differences on 12 of 1,399 recorded answers
- COMBINNumber of ways to pick k items from n when order does not matterMatches all 25,203 recorded answers
- COMBINANumber of ways to pick k items from n when items may repeat and order does not matterMatches all 40,995 recorded answers
- COSCosine of an angle in radiansMatches all 3,711 recorded answers
- COSHHyperbolic cosineMatches all 33,553 recorded answers
- COTCotangent of an angle in radiansMatches all 2,133 recorded answers
- COTHHyperbolic cotangentClose: 56 of 40,244 recorded answers differ in the last bits, worst 2 ULP
- CSCCosecant of an angle in radiansMatches all 2,139 recorded answers
- CSCHHyperbolic cosecantClose: 6 of 33,309 recorded answers differ in the last bits, worst 2 ULP
- DECIMALValue of a number written as text in a given baseMatches all 1,234 recorded answers
- DEGREESAngle in radians expressed in degreesRefuses 2 of 1,230 recorded calls; the rest match
- EVENNumber rounded away from zero to an even whole numberRefuses 2 of 1,373 recorded calls; the rest match
- EXPe raised to a powerMatches all 2,717 recorded answers
- FACTFactorial: the product 1 x 2 x ... x nMatches all 2,712 recorded answers
- FACTDOUBLEDouble factorial: the product of every second number down from nMatches all 2,713 recorded answers
- FLOOR.MATHNumber rounded down to a multiple of the significance, with a choice of direction for negative numbersRefuses 12 of 1,486 recorded calls; the rest match
- FLOOR.PRECISENumber rounded down toward minus infinity to a multiple of the significance, whatever its signKnown larger differences on 12 of 1,399 recorded answers
- GCDGreatest common divisor of whole numbersMatches all 7,972 recorded answers
- INTNumber rounded down to a whole numberKnown larger differences on 4 of 124,561 recorded answers
- ISO.CEILINGNumber rounded up toward plus infinity to a multiple of the significance (ISO form)Known larger differences on 12 of 1,339 recorded answers
- LCMLeast common multiple of whole numbersMatches all 7,973 recorded answers
- LNNatural logarithmMatches all 1,856 recorded answers
- LOGLogarithm in a given base (10 when the base is left out)Matches all 25,237 recorded answers
- LOG10Base-10 logarithmMatches all 2,866 recorded answers
- MDETERMDeterminant of a square matrixMatches all 4 recorded answers
- MINVERSEInverse of a square matrixMatches all 1,751 recorded answers
- MMULTMatrix multiplication: rows of the first array times columns of the secondMatches all 7 recorded answers
- MODRemainder after division, with the sign of the divisorMatches all 152,669 recorded answers
- MROUNDNumber rounded to the nearest multiple of anotherMatches all 50,949 recorded answers
- MULTINOMIALMultinomial coefficient: (a + b + ...)! / (a! b! ...)Matches all 6 recorded answers
- MUNITIdentity matrix of a given sizeMatches all 13 recorded answers
- ODDNumber rounded away from zero to an odd whole numberRefuses 2 of 1,374 recorded calls; the rest match
- PERCENTOFShare of a subset in a total, as a fractionMatches all 18 recorded answers
- PIThe constant pi, 3.14159265358979Matches all 15 recorded answers
- POWERA number raised to a powerClose: 2 of 62,781 recorded answers differ in the last bits, worst 1 ULP
- PRODUCTProduct of the numbersMatches all 1,244 recorded answers
- QUOTIENTWhole-number part of a divisionRefuses 12 of 1,522 recorded calls; the rest match
- RADIANSAngle in degrees expressed in radiansRefuses 2 of 32,928 recorded calls; the rest match
- RANDA random number from 0 up to but not including 1, new at each recalculationMatches all 2 recorded answers
- RANDARRAYAn array of random numbers of a given size, within limits, whole or decimalMatches all 2 recorded answers
- RANDBETWEENA random whole number between two limits, new at each recalculationMatches all 2 recorded answers
- ROMANA number written as a Roman numeral, in one of several stylesMatches all 4 recorded answers
- ROUNDNumber rounded to a number of digitsClose: 124 of 37,138 recorded answers differ in the last bits, worst 16 ULP
- ROUNDDOWNNumber rounded toward zero to a number of digitsKnown larger differences on 557 of 60,138 recorded answers
- ROUNDUPNumber rounded away from zero to a number of digitsKnown larger differences on 563 of 52,985 recorded answers
- SECSecant of an angle in radiansMatches all 2,141 recorded answers
- SECHHyperbolic secantClose: 1 of 30,427 recorded answers differ in the last bits, worst 1 ULP
- SEQUENCEAn array of evenly spaced numbers of a given sizeMatches all 52 recorded answers
- SERIESSUMSum of a power series with given coefficientsMatches all 7 recorded answers
- SIGN1 for a positive number, 0 for zero, -1 for a negative numberRefuses 2 of 1,364 recorded calls; the rest match
- SINSine of an angle in radiansMatches all 2,156 recorded answers
- SINHHyperbolic sineClose: 130 of 33,553 recorded answers differ in the last bits, worst 1 ULP
- SQRTSquare root of a number that is zero or moreRefuses 2 of 42,806 recorded calls; the rest match
- SQRTPISquare root of a number times piMatches all 1,227 recorded answers
- SUBTOTALA summary (sum, count, average and more) of a range that skips nested subtotalsMatches all 8 recorded answers
- SUMIFTotal of the cells that meet one conditionMatches all 32 recorded answers
- SUMPRODUCTSum of the products of matching items of arraysMatches all 66 recorded answers
- SUMSQSquares of the numbers, added upMatches all 1,238 recorded answers
- SUMX2MY2Sum of x squared minus y squared over matching itemsMatches all 7 recorded answers
- SUMX2PY2Sum of x squared plus y squared over matching itemsMatches all 6 recorded answers
- SUMXMY2Sum of the squared differences of matching itemsMatches all 6 recorded answers
- TANTangent of an angle in radiansMatches all 2,117 recorded answers
- TANHHyperbolic tangentClose: 58 of 39,031 recorded answers differ in the last bits, worst 1 ULP
- TRUNCNumber cut to a number of digits by dropping the restKnown larger differences on 557 of 51,465 recorded answers
Operators
- Addition (+)Known larger differences on 3 of 1,447 recorded answers
- Text concatenation (&)Known larger differences on 5 of 477 recorded answers
- Division (/)Matches all 198 recorded answers
- Equal to (=)Refuses 6 of 731 recorded calls; the rest match
- Greater than or equal to (>=)Matches all 4 recorded answers
- Greater than (>)Matches all 19 recorded answers
- Implicit intersection (@)Implemented; no recorded answers are attributed to this entry
- Intersection of references (space)Implemented; no recorded answers are attributed to this entry
- Less than or equal to (<=)Matches all 6 recorded answers
- Less than (<)Refuses 8 of 1,618 recorded calls; the rest match
- Multiplication (*)Matches all 5,661 recorded answers
- Negation (-)Implemented; no recorded answers are attributed to this entry
- Not equal to (<>)Matches all 5 recorded answers
- Percentage (%)Implemented; no recorded answers are attributed to this entry
- Exponentiation (^)Matches all 42 recorded answers
- Range reference (:)Implemented; no recorded answers are attributed to this entry
- Spill reference (#)Implemented; no recorded answers are attributed to this entry
- Subtraction (-)Known larger differences on 1 of 514 recorded answers
- Whitespace around a referenceImplemented; no recorded answers are attributed to this entry
- Whitespace before a referenceImplemented; no recorded answers are attributed to this entry
- Whitespace after a referenceImplemented; no recorded answers are attributed to this entry
- Unary plus (+)Implemented; no recorded answers are attributed to this entry
- Union of references (,)Implemented; no recorded answers are attributed to this entry
Our 10 featured functions
- COPILOTText generated by Copilot from a prompt and optional cell contextDeferred: needs an outside service
- COUNTHow many of the values are numbersMatches all 1,237 recorded answers
- COUNTIFSHow many cells meet every one of several conditionsMatches all 14 recorded answers
- FILTERThe rows or columns of an array for which a condition holdsMatches all 42 recorded answers
- IFOne of two values, chosen by whether a condition is TRUEMatches all 64 recorded answers
- LETA calculation that names intermediate results and uses themMatches all 58 recorded answers
- SUMTotal of the numbersMatches all 1,364 recorded answers
- SUMIFSTotal of the cells that meet every one of several conditionsMatches all 21 recorded answers
- TEXTBEFOREThe part of a text before a delimiterMatches all 22 recorded answers
- UNIQUEThe distinct rows or columns of an array, or those that occur only onceMatches all 5 recorded answers
- XLOOKUPThe item matching a search in one array, taken from another, with a fallback and match optionsMatches all 75 recorded answers
Statistical functions
- AVEDEVMean of the absolute distances of the values from their meanMatches all 1,218 recorded answers
- AVERAGEArithmetic mean of the numbers givenMatches all 1,288 recorded answers
- AVERAGEAArithmetic mean that also counts text as 0 and logical values as 1 or 0Matches all 1,232 recorded answers
- AVERAGEIFMean of the cells that meet one conditionMatches all 16 recorded answers
- AVERAGEIFSMean of the cells that meet every one of several conditionsMatches all 13 recorded answers
- BETA.DISTBeta distribution: the density or the cumulative probability, on an optional intervalKnown larger differences on 1,938 of 2,828 recorded answers
- BETA.INVThe value at which the cumulative beta distribution reaches a given probabilityClose: 1 of 6 recorded answers differ in the last bits, worst 2 ULP
- BINOM.DISTBinomial distribution: the chance of a number of successes in a number of trials, as a single value or cumulativeKnown larger differences on 303 of 70,656 recorded answers
- BINOM.DIST.RANGEChance that the number of binomial successes falls between two boundsKnown larger differences on 16 of 1,271 recorded answers
- BINOM.INVFewest successes whose cumulative binomial probability reaches a targetKnown larger differences on 3 of 2,162 recorded answers
- CHISQ.DISTChi-squared distribution: the density or the left-tail probabilityMatches all 5 recorded answers
- CHISQ.DIST.RTChi-squared upper-tail probability, P(X > x)Close: 1 of 10 recorded answers differ in the last bits, worst 2 ULP
- CHISQ.INVThe value at which the left-tail chi-squared probability reaches a given levelKnown larger differences on 29 of 44 recorded answers
- CHISQ.INV.RTThe value at which the right-tail chi-squared probability falls to a given levelMatches all 4 recorded answers
- CHISQ.TESTChi-squared test of independence between observed and expected counts, as a probabilityClose: 2 of 18 recorded answers differ in the last bits, worst 3 ULP
- CONFIDENCE.NORMHalf-width of a confidence interval for a mean, from the normal distributionClose: 1 of 5 recorded answers differ in the last bits, worst 2 ULP
- CONFIDENCE.THalf-width of a confidence interval for a mean, from Student's t distributionClose: 1 of 5 recorded answers differ in the last bits, worst 2 ULP
- CORRELPearson correlation coefficient of two data setsMatches all 7 recorded answers
- COUNTAHow many of the values are not emptyMatches all 1,234 recorded answers
- COUNTBLANKHow many cells of a range are emptyMatches all 14 recorded answers
- COUNTIFHow many cells meet one conditionMatches all 103 recorded answers
- COVARIANCE.PCovariance of two data sets taken as a whole populationMatches all 6 recorded answers
- COVARIANCE.SCovariance of two data sets taken as a sampleMatches all 6 recorded answers
- DEVSQSum of the squared distances of the values from their meanMatches all 23,172 recorded answers
- EXPON.DISTExponential distribution: the density or the cumulative probabilityClose: 1 of 49,370 recorded answers differ in the last bits, worst 1 ULP
- F.DISTF distribution: the density or the left-tail probabilityClose: 197 of 375 recorded answers differ in the last bits, worst 8 ULP
- F.DIST.RTRight-tail probability of the F distributionClose: 2 of 11 recorded answers differ in the last bits, worst 2 ULP
- F.INVThe value at which the left-tail F probability reaches a given levelClose: 1 of 5 recorded answers differ in the last bits, worst 1 ULP
- F.INV.RTThe value at which the right-tail F probability falls to a given levelClose: 1 of 5 recorded answers differ in the last bits, worst 1 ULP
- F.TESTTwo-tailed probability that two samples' variances do not differKnown larger differences on 61 of 84 recorded answers
- FISHERFisher transformation of a correlation, artanh(x)Matches all 34,169 recorded answers
- FISHERINVInverse Fisher transformation, tanh(y)Matches all 3 recorded answers
- FORECASTValue predicted for x on the least-squares line through the known pointsMatches all 78 recorded answers
- FORECAST.ETSFuture value by exponential triple smoothingNot implemented
- FORECAST.ETS.CONFINTConfidence interval of an exponential triple smoothing forecastNot implemented
- FORECAST.ETS.SEASONALITYLength of the repeating pattern found in a time seriesNot implemented
- FORECAST.ETS.STATA statistic of an exponential triple smoothing forecastNot implemented
- FORECAST.LINEARValue predicted for x on the least-squares line through the known pointsMatches all 7 recorded answers
- FREQUENCYHow many values fall into each bin, as a vertical arrayMatches all 7 recorded answers
- GAMMAGamma functionKnown larger differences on 6,197 of 12,606 recorded answers
- GAMMA.DISTGamma distribution: the density or the cumulative probabilityKnown larger differences on 29,887 of 78,071 recorded answers
- GAMMA.INVThe value at which the cumulative gamma distribution reaches a given probabilityKnown larger differences on 155 of 209 recorded answers
- GAMMALNNatural logarithm of the gamma functionClose: 2,403 of 4,541 recorded answers differ in the last bits, worst 7 ULP
- GAMMALN.PRECISENatural logarithm of the gamma functionClose: 3,638 of 14,281 recorded answers differ in the last bits, worst 7 ULP
- GAUSSProbability that a standard normal value lies between 0 and zClose: 357 of 9,731 recorded answers differ in the last bits, worst 3 ULP
- GEOMEANGeometric mean: the n-th root of the product of n positive valuesMatches all 1,977 recorded answers
- GROWTHValues predicted on the exponential curve fitted to known dataClose: 6 of 1,411 recorded answers differ in the last bits, worst 1 ULP
- HARMEANHarmonic mean: n divided by the sum of the reciprocalsMatches all 19,220 recorded answers
- HYPGEOM.DISTHypergeometric distribution: the chance of k successes in a sample drawn without replacementKnown larger differences on 208 of 3,759 recorded answers
- INTERCEPTWhere the least-squares line through the known points crosses the y-axisMatches all 11 recorded answers
- KURTSample excess kurtosis: how heavy the tails of the data areKnown larger differences on 1,299 of 4,514 recorded answers
- LARGEThe k-th largest valueMatches all 7 recorded answers
- LINESTCoefficients and statistics of the least-squares linear fitKnown larger differences on 253 of 3,345 recorded answers
- LOGESTCoefficients and statistics of the exponential curve fitted to the dataKnown larger differences on 243 of 2,417 recorded answers
- LOGNORM.DISTLognormal distribution: the density or the cumulative probabilityKnown larger differences on 3,891 of 7,815 recorded answers
- LOGNORM.INVThe value at which the cumulative lognormal distribution reaches a given probabilityClose: 1 of 5 recorded answers differ in the last bits, worst 2 ULP
- MAXLargest of the numbersMatches all 1,236 recorded answers
- MAXALargest value, counting text as 0 and logical values as 1 or 0Matches all 1,228 recorded answers
- MAXIFSLargest value among the cells that meet every conditionMatches all 18 recorded answers
- MEDIANMiddle value of the numbers once sortedMatches all 43,420 recorded answers
- MINSmallest of the numbersMatches all 1,230 recorded answers
- MINASmallest value, counting text as 0 and logical values as 1 or 0Matches all 1,227 recorded answers
- MINIFSSmallest value among the cells that meet every conditionMatches all 13 recorded answers
- MODE.MULTAll the most frequent numbers, as a vertical arrayMatches all 22 recorded answers
- MODE.SNGLMost frequent numberMatches all 22 recorded answers
- NEGBINOM.DISTNegative binomial distribution: the chance of f failures before the s-th successKnown larger differences on 169 of 607 recorded answers
- NORM.DISTNormal distribution with a given mean and standard deviation: density or cumulativeClose: 244 of 24,252 recorded answers differ in the last bits, worst 6 ULP
- NORM.INVThe value at which the cumulative normal distribution reaches a given probabilityMatches all 5 recorded answers
- NORM.S.DISTStandard normal distribution: density or cumulativeClose: 11,076 of 27,503 recorded answers differ in the last bits, worst 11 ULP
- NORM.S.INVThe z at which the cumulative standard normal distribution reaches a given probabilityMatches all 3 recorded answers
- PEARSONPearson correlation coefficient of two data setsMatches all 6 recorded answers
- PERCENTILE.EXCValue at a given percentile, with 0 and 1 excludedMatches all 5 recorded answers
- PERCENTILE.INCValue at a given percentile, with 0 and 1 includedMatches all 5 recorded answers
- PERCENTRANK.EXCRelative standing of a value in a data set, with 0 and 1 excludedMatches all 55 recorded answers
- PERCENTRANK.INCRelative standing of a value in a data set, with 0 and 1 includedMatches all 199 recorded answers
- PERMUTNumber of ordered arrangements of k items chosen from nMatches all 3,436 recorded answers
- PERMUTATIONANumber of ordered arrangements of k items from n when items may repeat: n to the power kClose: 4 of 71,919 recorded answers differ in the last bits, worst 1 ULP
- PHIDensity of the standard normal distribution at zMatches all 14,409 recorded answers
- POISSON.DISTPoisson distribution: the chance of a number of events, as a single value or cumulativeKnown larger differences on 878 of 49,925 recorded answers
- PROBProbability that values in a range fall between two limits, from their probabilitiesMatches all 8 recorded answers
- QUARTILE.EXCA quartile of a data set, from percentiles with 0 and 1 excludedMatches all 5 recorded answers
- QUARTILE.INCA quartile of a data set, from percentiles with 0 and 1 includedMatches all 5 recorded answers
- RANK.AVGRank of a number in a list, with tied values sharing their average rankMatches all 5 recorded answers
- RANK.EQRank of a number in a list, with tied values sharing the top rankMatches all 5 recorded answers
- RSQSquare of the Pearson correlation coefficient of two data setsMatches all 7 recorded answers
- SKEWSample skewness: how lopsided the data are around their meanKnown larger differences on 7 of 4,514 recorded answers
- SKEW.PPopulation skewnessMatches all 6 recorded answers
- SLOPESlope of the least-squares line through the known pointsMatches all 11 recorded answers
- SMALLThe k-th smallest valueMatches all 6 recorded answers
- STANDARDIZEz-score: distance from the mean in standard deviationsRefuses 8 of 10,315 recorded calls; the rest match
- STDEV.PStandard deviation of a whole populationMatches all 1,334 recorded answers
- STDEV.SStandard deviation of a sampleMatches all 1,319 recorded answers
- STDEVASample standard deviation counting text as 0 and logical values as 1 or 0Matches all 1,246 recorded answers
- STDEVPAPopulation standard deviation counting text as 0 and logical values as 1 or 0Matches all 1,227 recorded answers
- STEYXStandard error of the y values predicted by the least-squares lineMatches all 6 recorded answers
- T.DISTStudent's t distribution: the density or the left-tail probabilityClose: 1 of 5 recorded answers differ in the last bits, worst 1 ULP
- T.DIST.2TTwo-tailed probability of Student's t distributionClose: 1 of 4 recorded answers differ in the last bits, worst 11 ULP
- T.DIST.RTRight-tail probability of Student's t distributionKnown larger differences on 6 of 10 recorded answers
- T.INVThe t at which the left-tail probability reaches a given levelMatches all 4 recorded answers
- T.INV.2TThe t at which the two-tailed probability falls to a given levelClose: 1 of 4 recorded answers differ in the last bits, worst 1 ULP
- T.TESTProbability from Student's t-test that two samples have the same meanClose: 1 of 8 recorded answers differ in the last bits, worst 2 ULP
- TRENDValues predicted on the least-squares line fitted to known dataClose: 2 of 211 recorded answers differ in the last bits, worst 2 ULP
- TRIMMEANMean of the data after cutting a share of the values from both endsMatches all 131 recorded answers
- VAR.PVariance of a whole populationMatches all 1,491 recorded answers
- VAR.SVariance of a sampleMatches all 1,784 recorded answers
- VARASample variance counting text as 0 and logical values as 1 or 0Matches all 1,226 recorded answers
- VARPAPopulation variance counting text as 0 and logical values as 1 or 0Matches all 1,247 recorded answers
- WEIBULL.DISTWeibull distribution: the density or the cumulative probabilityClose: 2 of 31,489 recorded answers differ in the last bits, worst 2 ULP
- Z.TESTOne-tailed probability of a z-test for a sample meanClose: 3 of 7 recorded answers differ in the last bits, worst 3 ULP
Text functions
- ARRAYTOTEXTOne text holding all the values of an array or rangeMatches all 13 recorded answers
- ASCText with full-width (double-byte) characters turned into their half-width formsMatches all 14 recorded answers
- BAHTTEXTA number spelled out in Thai words as an amount in bahtMatches all 2,595 recorded answers
- CHARCharacter with a given code in the system character setMatches all 145 recorded answers
- CLEANText with the non-printing control characters taken outMatches all 5 recorded answers
- CODECode of the first character of a text in the system character setMatches all 7 recorded answers
- CONCATAll the texts of the arguments and ranges joined end to endKnown larger differences on 5 of 63 recorded answers
- DBCSText with half-width (single-byte) characters turned into their full-width formsMatches all 17 recorded answers
- DETECTLANGUAGECode of the language a text is written inDeferred: needs an outside service
- DOLLARA number as currency text, rounded to a number of decimalsMatches all 7 recorded answers
- EXACTTRUE when two texts are identical, letter case includedMatches all 8 recorded answers
- FINDPosition of one text inside another, case-sensitiveMatches all 47 recorded answers
- FINDBPosition of one text inside another, case-sensitive, counted in bytes for double-byte languagesMatches all 6 recorded answers
- FIXEDA number as text with a fixed number of decimals, with or without thousands separatorsRefuses 788 of 1,000 recorded calls; the rest match
- LEFTThe first characters of a textMatches all 17 recorded answers
- LEFTBThe first characters of a text, counted in bytes for double-byte languagesMatches all 5 recorded answers
- LENText length in charactersMatches all 48 recorded answers
- LENBNumber of bytes a text takes in double-byte languagesMatches all 13 recorded answers
- LOWERText in lower caseMatches all 11 recorded answers
- MIDCharacters from the middle of a text, from a start position for a given lengthMatches all 14 recorded answers
- MIDBCharacters from the middle of a text, counted in bytes for double-byte languagesMatches all 7 recorded answers
- NUMBERVALUENumber read from text with the given decimal and group separatorsMatches all 8 recorded answers
- PHONETICThe phonetic (furigana) reading stored with Japanese textMatches all 3 recorded answers
- PROPERText with the first letter of each word in upper case and the rest in lower caseMatches all 8 recorded answers
- REGEXEXTRACTText matched by a regular expressionMatches all 26 recorded answers
- REGEXREPLACEText with the matches of a regular expression replacedMatches all 8 recorded answers
- REGEXTESTTRUE when a text matches a regular expressionMatches all 12 recorded answers
- REPLACEText with a span of characters replaced by other textMatches all 8 recorded answers
- REPLACEBText with a span of bytes replaced by other text, for double-byte languagesMatches all 7 recorded answers
- REPTA text repeated a number of timesMatches all 12 recorded answers
- RIGHTThe last characters of a textMatches all 14 recorded answers
- RIGHTBThe last characters of a text, counted in bytes for double-byte languagesMatches all 5 recorded answers
- SEARCHPosition of one text inside another, ignoring letter case and allowing wildcardsMatches all 57 recorded answers
- SEARCHBPosition of one text inside another, ignoring case, counted in bytes for double-byte languagesMatches all 6 recorded answers
- SUBSTITUTEText with occurrences of one text replaced by anotherMatches all 9 recorded answers
- TThe value when it is text, otherwise empty textMatches all 1,233 recorded answers
- TEXTA value as text, in a number formatMatches all 1,396 recorded answers
- TEXTAFTERThe part of a text after a delimiterMatches all 22 recorded answers
- TEXTJOINTexts joined with a delimiter, optionally skipping empty onesMatches all 26 recorded answers
- TEXTSPLITA text split into rows and columns at delimitersRefuses 2 of 51 recorded calls; the rest match
- TRANSLATEA text translated from one language to anotherDeferred: needs an outside service
- TRIMText with spaces removed at both ends and runs of spaces inside cut to oneMatches all 5 recorded answers
- UNICHARCharacter with a given Unicode code pointMatches all 285 recorded answers
- UNICODEUnicode code point of the first character of a textMatches all 6 recorded answers
- UPPERText in upper caseMatches all 10 recorded answers
- VALUENumber read from textMatches all 59 recorded answers
- VALUETOTEXTText for any value, in a concise or a formula-ready formMatches all 6 recorded answers
User defined functions that are installed with add-ins
- CALLRuns a procedure from a code library (DLL) and gives back its resultNeeds a host that can load code
- EUROCONVERTAn amount converted between euro member currencies through the euroNot yet implemented
- REGISTER.IDIdentifier of a registered procedure in a code library (DLL)Needs a host that can load code
Web functions
- ENCODEURLText made safe for a URL by percent-encodingMatches all 113 recorded answers
- FILTERXMLValues picked out of XML text by an XPath expressionMatches all 83 recorded answers
- WEBSERVICEText fetched from a web service at a URLNot yet implemented
No matching entries. Try a function name or clear the filters.