Formula library
Excel functions
The full A to Z, cross-checked against official lists in November 2026. Each row shows whether the same function works on the other platform.
Function
A built-in tool with a name
SUM, XLOOKUP and IF are functions. Excel and Sheets supply them.
SUMFormula
Any calculation you write
A formula starts with = and can use functions, cells and operators.
=SUM(B2:B10)*1.05530 of 530 Excel functions
| Function | In Sheets? |
|---|---|
| ABSReturns absolute value | Yes |
| ACCRINTAccrued interest for periodic-interest security | Yes |
| ACCRINTMAccrued interest for security paying at maturity | Yes |
| ACOSArccosine | Yes |
| ACOSHInverse hyperbolic cosine | Yes |
| ACOTArccotangent | Yes |
| ACOTHHyperbolic arccotangent | Yes |
| ADDRESSCell reference as text | Yes |
| AGGREGATEAggregate across a list or database | Use SUBTOTAL |
| AMORDEGRCDepreciation per period using a coefficient | No |
| AMORLINCDepreciation per accounting period | Yes |
| ANDTRUE if all arguments are TRUE | Yes |
| ARABICConverts Roman numeral to Arabic number | Yes |
| AREASNumber of areas in a reference | No |
| ARRAYTOTEXTArray of text values from a range | Use JOIN |
| ASCFull-width characters to half-width | Yes |
| ASINArcsine | Yes |
| ASINHInverse hyperbolic sine | Yes |
| ATANArctangent | Yes |
| ATAN2Arctangent from x and y coordinates | Yes |
| ATANHInverse hyperbolic tangent | Yes |
| AVEDEVAverage absolute deviation from mean | Yes |
| AVERAGEAverage of arguments | Yes |
| AVERAGEAAverage including text and logical values | Yes |
| AVERAGEIFAverage of cells meeting one criterion | Yes |
| AVERAGEIFSAverage of cells meeting multiple criteria | Yes |
| BAHTTEXTNumber to text in baht currency format | No |
| BASENumber to text in a given base | Yes |
| BESSELIModified Bessel function In(x) | No |
| BESSELJBessel function Jn(x) | No |
| BESSELKModified Bessel function Kn(x) | No |
| BESSELYBessel function Yn(x) | No |
| BETA.DISTBeta cumulative distribution | Yes |
| BETA.INVInverse beta cumulative distribution | Yes |
| BETADISTBeta cumulative distribution | Yes |
| BETAINVInverse beta cumulative distribution | Yes |
| BIN2DECBinary to decimal | Yes |
| BIN2HEXBinary to hexadecimal | Yes |
| BIN2OCTBinary to octal | Yes |
| BINOM.DISTIndividual-term binomial probability | Yes |
| BINOM.DIST.RANGEProbability of a result range under binomial distribution | No |
| BINOM.INVSmallest value with cumulative binomial at or above criterion | Yes |
| BINOMDISTIndividual-term binomial probability | Yes |
| BITANDBitwise AND | Yes |
| BITLSHIFTShift value left by bits | Yes |
| BITORBitwise OR | Yes |
| BITRSHIFTShift value right by bits | Yes |
| BITXORBitwise XOR | Yes |
| BYCOLApplies LAMBDA to each column | Yes |
| BYROWApplies LAMBDA to each row | Yes |
| CALLCalls a procedure in a DLL or code resource | No |
| CEILINGRounds up to a multiple of significance | Yes |
| CEILING.MATHRounds up to integer or multiple of significance | Yes |
| CEILING.PRECISERounds up to integer or multiple, regardless of sign | Yes |
| CELLInfo about a cell's format, location, or contents | Yes |
| CHARCharacter for a code number | Yes |
| CHIDISTOne-tailed chi-squared probability | Yes |
| CHIINVInverse one-tailed chi-squared probability | Yes |
| CHISQ.DISTChi-squared distribution function | Yes |
| CHISQ.DIST.RTOne-tailed chi-squared probability | Yes |
| CHISQ.INVInverse chi-squared distribution | Yes |
| CHISQ.INV.RTInverse one-tailed chi-squared probability | Yes |
| CHISQ.TESTChi-squared independence test | Yes |
| CHITESTChi-squared independence test | Yes |
| CHOOSEPicks a value from a list by position | Yes |
| CHOOSECOLSReturns specified columns from an array | Yes |
| CHOOSEROWSReturns specified rows from an array | Yes |
| CLEANRemoves nonprintable characters | Yes |
| CODENumeric code of first character | Yes |
| COLUMNColumn number of a reference | Yes |
| COLUMNSNumber of columns in a reference | Yes |
| COMBINNumber of combinations | Yes |
| COMBINACombinations with repetition | Yes |
| COMPLEXBuilds complex number from coefficients | Yes |
| CONCATJoins text from ranges and/or strings | Yes |
| CONCATENATEJoins text items | Yes |
| CONFIDENCEConfidence interval for a mean | Yes |
| CONFIDENCE.NORMConfidence interval for a mean (normal) | Yes |
| CONFIDENCE.TConfidence interval for a mean (Student's t) | Yes |
| CONVERTConverts between measurement units | Yes |
| COPILOT GuideRuns an AI prompt from a cell | Use AI |
| CORRELCorrelation coefficient of two data sets | Yes |
| COSCosine | Yes |
| COSHHyperbolic cosine | Yes |
| COTCotangent | Yes |
| COTHHyperbolic cotangent | Yes |
| COUNTCounts numeric values in arguments | Yes |
| COUNTACounts non-empty values in arguments | Yes |
| COUNTBLANKCounts blank cells in a range | Yes |
| COUNTIFCounts cells meeting one criterion | Yes |
| COUNTIFSCounts cells meeting multiple criteria | Yes |
| COUPDAYBSDays from coupon period start to settlement | Yes |
| COUPDAYSDays in coupon period containing settlement | Yes |
| COUPDAYSNCDays from settlement to next coupon | Yes |
| COUPNCDNext coupon date after settlement | Yes |
| COUPNUMNumber of coupons between settlement and maturity | Yes |
| COUPPCDPrevious coupon date before settlement | Yes |
| COVARCovariance (population) | Yes |
| COVARIANCE.PPopulation covariance | Yes |
| COVARIANCE.SSample covariance | Yes |
| CRITBINOMSmallest cumulative binomial at or above criterion | Yes |
| CSCCosecant | Yes |
| CSCHHyperbolic cosecant | Yes |
| CUBEKPIMEMBERReturns KPI name, property, and measure | No |
| CUBEMEMBERReturns member or tuple from a cube | No |
| CUBEMEMBERPROPERTYReturns a member property value | No |
| CUBERANKEDMEMBERReturns nth-ranked member in a set | No |
| CUBESETDefines a calculated set on the server | No |
| CUBESETCOUNTNumber of items in a set | No |
| CUBEVALUEAggregated value from a cube | No |
| CUMIPMTCumulative interest between two periods | Yes |
| CUMPRINCCumulative principal between two periods | Yes |
| DATESerial number for a date | Yes |
| DATEDIFDays, months, or years between dates | Yes |
| DATEVALUEConverts date text to serial number | Yes |
| DAVERAGEAverage of matching database entries | Yes |
| DAYDay of month from serial number | Yes |
| DAYSDays between two dates | Yes |
| DAYS360Days between dates on a 360-day year | Yes |
| DBDepreciation by fixed-declining balance | Yes |
| DBCSHalf-width to full-width characters | No |
| DCOUNTCounts numeric cells in matching records | Yes |
| DCOUNTACounts non-blank cells in matching records | Yes |
| DDBDepreciation by double-declining balance | Yes |
| DEC2BINDecimal to binary | Yes |
| DEC2HEXDecimal to hexadecimal | Yes |
| DEC2OCTDecimal to octal | Yes |
| DECIMALText in a given base to decimal | Yes |
| DEGREESRadians to degrees | Yes |
| DELTATests whether two values are equal | Yes |
| DETECTLANGUAGEIdentifies language of text | Yes |
| DEVSQSum of squared deviations | Yes |
| DGETExtracts single record matching criteria | Yes |
| DISCDiscount rate for a security | Yes |
| DMAXMaximum of matching entries | Yes |
| DMINMinimum of matching entries | Yes |
| DOLLARNumber to text in dollar currency format | Yes |
| DOLLARDEFractional dollar price to decimal | Yes |
| DOLLARFRDecimal dollar price to fractional | Yes |
| DPRODUCTProduct of field values in matching records | Yes |
| DROPRemoves rows or columns from an array edge | No |
| DSTDEVSample standard deviation of matching entries | Yes |
| DSTDEVPPopulation standard deviation of matching entries | Yes |
| DSUMSum of field values in matching records | Yes |
| DURATIONAnnual duration of periodic-interest security | Yes |
| DVARSample variance of matching entries | Yes |
| DVARPPopulation variance of matching entries | Yes |
| ECMA.CEILINGRounds up to a multiple of significance | No |
| EDATEDate a number of months before or after start | Yes |
| EFFECTEffective annual interest rate | Yes |
| ENCODEURLURL-encoded string | Yes |
| EOMONTHLast day of month, offset by months | Yes |
| ERFError function | Yes |
| ERF.PRECISEError function | Yes |
| ERFCComplementary error function | Yes |
| ERFC.PRECISEComplementary error function | Yes |
| ERROR.TYPENumber matching an error type | Yes |
| EUROCONVERTConverts currency to/from euro and member currencies | No |
| EVENRounds up to nearest even integer | Yes |
| EXACTChecks if two texts are identical | Yes |
| EXPe raised to a power | Yes |
| EXPANDExpands or pads an array to given dimensions | No |
| EXPON.DISTExponential distribution | Yes |
| EXPONDISTExponential distribution | Yes |
| F.DISTF probability distribution | Yes |
| F.DIST.RTF probability distribution (right-tailed) | Yes |
| F.INVInverse F distribution | Yes |
| F.INV.RTInverse F distribution (right-tailed) | Yes |
| F.TESTF-test result | Yes |
| FACTFactorial | Yes |
| FACTDOUBLEDouble factorial | Yes |
| FALSEReturns FALSE | Yes |
| FDISTF probability distribution | Yes |
| FIELDVALUEValue from a field of a linked data type | No |
| FILTER GuideFilters data by criteria | Yes |
| FILTERXMLExtracts data from XML via XPath | Use IMPORTXML |
| FINDFinds text within text (case-sensitive) | Yes |
| FINDBFinds text within text, counting double-byte characters as 2 | Yes |
| FINVInverse F distribution | Yes |
| FISHERFisher transformation | Yes |
| FISHERINVInverse Fisher transformation | Yes |
| FIXEDFormats number as text with fixed decimals | Yes |
| FLOORRounds down to a multiple of significance | Yes |
| FLOOR.MATHRounds down to integer or multiple | Yes |
| FLOOR.PRECISERounds down to integer or multiple, regardless of sign | Yes |
| FORECASTLinear trend value (legacy) | Yes |
| FORECAST.ETSFuture value via exponential smoothing | No |
| FORECAST.ETS.CONFINTConfidence interval for ETS forecast | No |
| FORECAST.ETS.SEASONALITYLength of seasonal pattern in time series | No |
| FORECAST.ETS.STATStatistical value from ETS forecasting | No |
| FORECAST.LINEARFuture value on a linear trend | Yes |
| FORMULATEXTFormula at a reference, as text | Yes |
| FREQUENCYFrequency distribution as vertical array | Yes |
| FTESTF-test result | Yes |
| FVFuture value of investment | Yes |
| FVSCHEDULEFuture value after series of rates | Yes |
| GAMMAGamma function value | Yes |
| GAMMA.DISTGamma distribution | Yes |
| GAMMA.INVInverse gamma cumulative distribution | Yes |
| GAMMADISTGamma distribution | Yes |
| GAMMAINVInverse gamma cumulative distribution | Yes |
| GAMMALNNatural log of gamma function | Yes |
| GAMMALN.PRECISENatural log of gamma function | Yes |
| GAUSSStandard normal cumulative distribution minus 0.5 | Yes |
| GCDGreatest common divisor | Yes |
| GEOMEANGeometric mean | Yes |
| GESTEPTests if number meets a threshold | Yes |
| GETPIVOTDATAData from a PivotTable | Yes |
| GROUPBYGroups, aggregates, sorts, and filters data | Use QUERY |
| GROWTHValues on an exponential trend | Yes |
| HARMEANHarmonic mean | Yes |
| HEX2BINHexadecimal to binary | Yes |
| HEX2DECHexadecimal to decimal | Yes |
| HEX2OCTHexadecimal to octal | Yes |
| HLOOKUPSearches top row, returns value from indicated row | Yes |
| HOURHour from serial number | Yes |
| HSTACKAppends arrays horizontally | Yes |
| HYPERLINKCreates a clickable link | Yes |
| HYPGEOM.DISTHypergeometric distribution | Yes |
| HYPGEOMDISTHypergeometric distribution | Yes |
| IFPerforms a logical test | Yes |
| IFERROR GuideValue on error, otherwise formula result | Yes |
| IFNAValue if #N/A, otherwise formula result | Yes |
| IFSValue for first TRUE condition | Yes |
| IMABSModulus of complex number | Yes |
| IMAGEReturns an image from a source | Yes |
| IMAGINARYImaginary coefficient of complex number | Yes |
| IMARGUMENTArgument (theta) of complex number in radians | Yes |
| IMCONJUGATEComplex conjugate | Yes |
| IMCOSCosine of complex number | Yes |
| IMCOSHHyperbolic cosine of complex number | Yes |
| IMCOTCotangent of complex number | Yes |
| IMCSCCosecant of complex number | Yes |
| IMCSCHHyperbolic cosecant of complex number | Yes |
| IMDIVQuotient of complex numbers | Yes |
| IMEXPExponential of complex number | Yes |
| IMLNNatural log of complex number | Yes |
| IMLOG10Base-10 log of complex number | Yes |
| IMLOG2Base-2 log of complex number | Yes |
| IMPORTCSVImports data from a CSV file | Use IMPORTDATA |
| IMPORTTEXTImports data from a text file | Use IMPORTDATA |
| IMPOWERComplex number to integer power | Yes |
| IMPRODUCTProduct of complex numbers | Yes |
| IMREALReal coefficient of complex number | Yes |
| IMSECSecant of complex number | Yes |
| IMSECHHyperbolic secant of complex number | Yes |
| IMSINSine of complex number | Yes |
| IMSINHHyperbolic sine of complex number | Yes |
| IMSQRTSquare root of complex number | Yes |
| IMSUBDifference of complex numbers | Yes |
| IMSUMSum of complex numbers | Yes |
| IMTANTangent of complex number | Yes |
| INDEX GuideValue at position in a reference or array | Yes |
| INDIRECTReference specified by text | Yes |
| INFOInfo about operating environment | No |
| INTRounds down to nearest integer | Yes |
| INTERCEPTIntercept of linear regression line | Yes |
| INTRATEInterest rate for fully invested security | Yes |
| IPMTInterest payment for a period | Yes |
| IRRInternal rate of return | Yes |
| ISBLANKTRUE if blank | Yes |
| ISERRTRUE for any error except #N/A | Yes |
| ISERRORTRUE for any error | Yes |
| ISEVENTRUE if number is even | Yes |
| ISFORMULATRUE if referenced cell has a formula | Yes |
| ISLOGICALTRUE if logical value | Yes |
| ISNATRUE if #N/A | Yes |
| ISNONTEXTTRUE if not text | Yes |
| ISNUMBERTRUE if number | Yes |
| ISO.CEILINGRounds up to integer or multiple (ISO) | Yes |
| ISODDTRUE if number is odd | Yes |
| ISOMITTEDTRUE if LAMBDA parameter is missing | No |
| ISOWEEKNUMISO week number of year | Yes |
| ISPMTInterest paid during a period | Yes |
| ISREFTRUE if reference | Yes |
| ISTEXTTRUE if text | Yes |
| JISHalf-width to full-width characters | No |
| KURTKurtosis of data set | Yes |
| LAMBDACreates custom reusable functions | Yes |
| LARGEk-th largest value | Yes |
| LCMLeast common multiple | Yes |
| LEFTLeftmost characters | Yes |
| LEFTBLeftmost characters, by bytes | Yes |
| LENNumber of characters in text | Yes |
| LENBNumber of bytes in text | Yes |
| LET GuideNames calculation results | Yes |
| LINESTParameters of linear trend | Yes |
| LNNatural logarithm | Yes |
| LOGLogarithm to specified base | Yes |
| LOG10Base-10 logarithm | Yes |
| LOGESTParameters of exponential trend | Yes |
| LOGINVInverse lognormal distribution | Yes |
| LOGNORM.DISTCumulative lognormal distribution | Yes |
| LOGNORM.INVInverse lognormal distribution | Yes |
| LOGNORMDISTCumulative lognormal distribution | Yes |
| LOOKUPLooks up values in vector or array | Yes |
| LOWERConverts text to lowercase | Yes |
| MAKEARRAYBuilds array of given size using LAMBDA | Yes |
| MAPMaps array values to new values via LAMBDA | Yes |
| MATCHPosition of value in range or array | Yes |
| MAXMaximum value in arguments | Yes |
| MAXAMaximum including text and logical values | Yes |
| MAXIFSMaximum among cells meeting criteria | Yes |
| MDETERMMatrix determinant | Yes |
| MDURATIONModified Macaulay duration | Yes |
| MEDIANMedian of numbers | Yes |
| MIDCharacters from a position in text | Yes |
| MIDBCharacters from a position in text, by bytes | Yes |
| MINMinimum value in arguments | Yes |
| MINAMinimum including text and logical values | Yes |
| MINIFSMinimum among cells meeting criteria | Yes |
| MINUTEMinute from serial number | Yes |
| MINVERSEMatrix inverse | Yes |
| MIRRIRR with separate finance and reinvestment rates | Yes |
| MMULTMatrix product | Yes |
| MODRemainder after division | Yes |
| MODEMost common value | Yes |
| MODE.MULTVertical array of most frequent values | Yes |
| MODE.SNGLMost common value | Yes |
| MONTHMonth from serial number | Yes |
| MROUNDRounds to a desired multiple | Yes |
| MULTINOMIALMultinomial of numbers | Yes |
| MUNITUnit matrix of given dimension | Yes |
| NConverts value to number | Yes |
| NAReturns #N/A error | Yes |
| NEGBINOM.DISTNegative binomial distribution | Yes |
| NEGBINOMDISTNegative binomial distribution | Yes |
| NETWORKDAYSWhole workdays between dates | Yes |
| NETWORKDAYS.INTLWorkdays between dates with custom weekends | Yes |
| NOMINALAnnual nominal interest rate | Yes |
| NORM.DISTNormal cumulative distribution | Yes |
| NORM.INVInverse normal distribution | Yes |
| NORM.S.DISTStandard normal cumulative distribution | Yes |
| NORM.S.INVInverse standard normal distribution | Yes |
| NORMDISTNormal cumulative distribution | Yes |
| NORMINVInverse normal distribution | Yes |
| NORMSDISTStandard normal cumulative distribution | Yes |
| NORMSINVInverse standard normal distribution | Yes |
| NOTReverses a logical value | Yes |
| NOWCurrent date and time | Yes |
| NPERNumber of investment periods | Yes |
| NPVNet present value of periodic cash flows | Yes |
| NUMBERVALUELocale-independent text to number | No |
| OCT2BINOctal to binary | Yes |
| OCT2DECOctal to decimal | Yes |
| OCT2HEXOctal to hexadecimal | Yes |
| ODDRounds up to nearest odd integer | Yes |
| ODDFPRICEPrice for security with odd first period | No |
| ODDFYIELDYield for security with odd first period | No |
| ODDLPRICEPrice for security with odd last period | No |
| ODDLYIELDYield for security with odd last period | No |
| OFFSETReference offset from a starting reference | Yes |
| ORTRUE if any argument is TRUE | Yes |
| PDURATIONPeriods needed to reach a value | Yes |
| PEARSONPearson correlation coefficient | Yes |
| PERCENTILEk-th percentile | Yes |
| PERCENTILE.EXCk-th percentile, exclusive | Yes |
| PERCENTILE.INCk-th percentile, inclusive | Yes |
| PERCENTOFSubset sum as share of total | No |
| PERCENTRANKPercentage rank | Yes |
| PERCENTRANK.EXCPercentage rank, exclusive | Yes |
| PERCENTRANK.INCPercentage rank, inclusive | Yes |
| PERMUTNumber of permutations | Yes |
| PERMUTATIONAPermutations with repetition | Yes |
| PHIStandard normal density at a value | Yes |
| PHONETICExtracts phonetic (furigana) characters | No |
| PIValue of pi | Yes |
| PIVOTBYGroups and aggregates by row and column fields | Use QUERY |
| PMT GuidePeriodic annuity payment | Yes |
| POISSONPoisson distribution | Yes |
| POISSON.DISTPoisson distribution | Yes |
| POWERNumber raised to a power | Yes |
| PPMTPrincipal portion of a payment | Yes |
| PRICEPrice for periodic-interest security | Yes |
| PRICEDISCPrice for discounted security | Yes |
| PRICEMATPrice for security paying at maturity | Yes |
| PROBProbability values fall between limits | Yes |
| PRODUCTMultiplies arguments | Yes |
| PROPERCapitalizes first letter of each word | Yes |
| PVPresent value of investment | Yes |
| PYRuns Python code in a cell (Python in Excel) | No |
| QUARTILEQuartile of data set | Yes |
| QUARTILE.EXCQuartile, exclusive | Yes |
| QUARTILE.INCQuartile, inclusive | Yes |
| QUOTIENTInteger portion of division | Yes |
| RADIANSDegrees to radians | Yes |
| RANDRandom number from 0 to 1 | Yes |
| RANDARRAYArray of random numbers | Yes |
| RANDBETWEENRandom integer between two values | Yes |
| RANKRank in list | Yes |
| RANK.AVGRank in list, averaging ties | Yes |
| RANK.EQRank in list, equal ranks for ties | Yes |
| RATEInterest rate per period of annuity | Yes |
| RECEIVEDAmount received at maturity | Yes |
| REDUCEReduces array to one value via LAMBDA | Yes |
| REGEXEXTRACTExtracts text matching a pattern | Yes |
| REGEXREPLACEReplaces text matching a pattern | Yes |
| REGEXTESTTRUE if text matches a pattern | Use REGEXMATCH |
| REGISTER.IDRegister ID of a registered DLL | No |
| REPLACEReplaces characters within text | Yes |
| REPLACEBReplaces characters within text, by bytes | Yes |
| REPTRepeats text a number of times | Yes |
| RIGHTRightmost characters | Yes |
| RIGHTBRightmost characters, by bytes | Yes |
| ROMANArabic numeral to Roman text | Yes |
| ROUNDRounds to specified digits | Yes |
| ROUNDDOWNRounds toward zero | Yes |
| ROUNDUPRounds away from zero | Yes |
| ROWRow number of a reference | Yes |
| ROWSNumber of rows in a reference | Yes |
| RRIEquivalent growth rate of investment | Yes |
| RSQSquare of Pearson correlation | Yes |
| RTDReal-time data from COM automation program | No |
| SCANApplies LAMBDA and returns intermediate values | Yes |
| SEARCHFinds text within text (not case-sensitive) | Yes |
| SEARCHBFinds text within text, counting double-byte characters as 2 | Yes |
| SECSecant | Yes |
| SECHHyperbolic secant | Yes |
| SECONDSecond from serial number | Yes |
| SEQUENCEGenerates sequential numbers in an array | Yes |
| SERIESSUMSum of a power series | Yes |
| SHEETSheet number of a reference | Yes |
| SHEETSNumber of sheets in a reference | Yes |
| SIGNSign of a number | Yes |
| SINSine | Yes |
| SINGLEReturns a single value using implicit intersection | No |
| SINHHyperbolic sine | Yes |
| SKEWSkewness of distribution | Yes |
| SKEW.PPopulation skewness | Yes |
| SLNStraight-line depreciation per period | Yes |
| SLOPESlope of linear regression line | Yes |
| SMALLk-th smallest value | Yes |
| SORTSorts range or array | Yes |
| SORTBYSorts range by values in another range | Use SORT |
| SQL.REQUESTQueries an external data source | No |
| SQRTPositive square root | Yes |
| SQRTPISquare root of (number x pi) | Yes |
| STANDARDIZENormalized value | Yes |
| STDEVSample standard deviation | Yes |
| STDEV.PPopulation standard deviation | Yes |
| STDEV.SSample standard deviation | Yes |
| STDEVASample standard deviation including text and logicals | Yes |
| STDEVPPopulation standard deviation | Yes |
| STDEVPAPopulation standard deviation including text and logicals | Yes |
| STEYXStandard error of predicted y-values | Yes |
| STOCKHISTORYHistorical financial data as array | Use GOOGLEFINANCE |
| SUBSTITUTEReplaces old text with new text | Yes |
| SUBTOTALSubtotal in list or database | Yes |
| SUMAdds arguments | Yes |
| SUMIFSums cells meeting one criterion | Yes |
| SUMIFS GuideSums cells meeting multiple criteria | Yes |
| SUMPRODUCTSum of products of array components | Yes |
| SUMSQSum of squares of arguments | Yes |
| SUMX2MY2Sum of differences of squares of two arrays | Yes |
| SUMX2PY2Sum of sums of squares of two arrays | Yes |
| SUMXMY2Sum of squared differences of two arrays | Yes |
| SWITCHReturns result for first matching value | Yes |
| SYDSum-of-years' digits depreciation | Yes |
| TConverts arguments to text | Yes |
| T.DISTStudent's t distribution | Yes |
| T.DIST.2TTwo-tailed Student's t distribution | Yes |
| T.DIST.RTRight-tailed Student's t distribution | Yes |
| T.INVInverse left-tailed Student's t | Yes |
| T.INV.2TInverse two-tailed Student's t | Yes |
| T.TESTProbability from Student's t-test | Yes |
| TABLEInternal function behind What-If data tables | No |
| TAKEReturns contiguous rows or columns from array edge | Use ARRAY_CONSTRAIN |
| TANTangent | Yes |
| TANHHyperbolic tangent | Yes |
| TBILLEQBond-equivalent yield for Treasury bill | Yes |
| TBILLPRICEPrice for Treasury bill | Yes |
| TBILLYIELDYield for Treasury bill | Yes |
| TDISTStudent's t distribution | Yes |
| TEXTFormats number and converts to text | Yes |
| TEXTAFTERText after a delimiter | Use REGEXEXTRACT |
| TEXTBEFOREText before a delimiter | Use REGEXEXTRACT |
| TEXTJOINCombines text with a delimiter | Yes |
| TEXTSPLIT GuideSplits text by delimiters | Use SPLIT |
| TIMESerial number for a time | Yes |
| TIMEVALUEConverts time text to serial number | Yes |
| TINVInverse Student's t distribution | Yes |
| TOCOLReturns array as single column | Yes |
| TODAYToday's date | Yes |
| TOROWReturns array as single row | Yes |
| TRANSLATETranslates text between languages | Use GOOGLETRANSLATE |
| TRANSPOSETransposes array rows and columns | Yes |
| TRENDValues on linear trend | Yes |
| TRIMRemoves extra spaces | Yes |
| TRIMMEANMean of data set interior | Yes |
| TRIMRANGETrims blank edges from range | No |
| TRUEReturns TRUE | Yes |
| TRUNCTruncates to integer | Yes |
| TTESTProbability from Student's t-test | Yes |
| TYPENumber indicating data type | Yes |
| UNICHARUnicode character for a number | Yes |
| UNICODEUnicode number of first character | Yes |
| UNIQUEUnique values in list or range | Yes |
| UPPERConverts text to uppercase | Yes |
| VALUEConverts text to number | Yes |
| VALUETOTEXTText from any value | Use TO_TEXT |
| VARSample variance | Yes |
| VAR.PPopulation variance | Yes |
| VAR.SSample variance | Yes |
| VARASample variance including text and logicals | Yes |
| VARPPopulation variance | Yes |
| VARPAPopulation variance including text and logicals | Yes |
| VDBDepreciation over specified or partial period | Yes |
| VLOOKUP GuideSearches first column, returns value from same row | Yes |
| VSTACKAppends arrays vertically | Yes |
| WEBSERVICEData from a web service | Use IMPORTDATA |
| WEEKDAYDay of week from serial number | Yes |
| WEEKNUMWeek number within year | Yes |
| WEIBULLWeibull distribution | Yes |
| WEIBULL.DISTWeibull distribution | Yes |
| WORKDAYDate before/after given workdays | Yes |
| WORKDAY.INTLWorkdays with custom weekend parameters | Yes |
| WRAPCOLSWraps row or column into columns | Yes |
| WRAPROWSWraps row or column into rows | Yes |
| XIRRIRR for non-periodic cash flows | Yes |
| XLOOKUP GuideSearches range, returns match | Yes |
| XMATCHRelative position of item in range | Use MATCH |
| XNPVNPV for non-periodic cash flows | Yes |
| XORLogical exclusive OR of arguments | Yes |
| YEARYear from serial number | Yes |
| YEARFRACYear fraction between two dates | Yes |
| YIELDYield for periodic-interest security | Yes |
| YIELDDISCAnnual yield for discounted security | Yes |
| YIELDMATYield for security paying at maturity | Yes |
| Z.TESTOne-tailed z-test probability | Yes |
| ZTESTOne-tailed z-test probability | Yes |