Excel function reference
Every function, explained with examples you can edit live.
310 of Excel’s 519 functions so far — syntax, realistic worked examples, and the Google Sheets equivalent for each. New functions land every week.
Looking for Google Sheets?Excel math functions
Math — 80 functions and counting.
- ABSReturns the absolute value of a numberMathGoogle Sheets
- ACOSReturns the arccosine of a numberMathGoogle Sheets
- ACOSHReturns the inverse hyperbolic cosine of a numberMathGoogle Sheets
- ACOTReturns the arccotangent of a numberMathGoogle Sheets
- ACOTHReturns the hyperbolic arccotangent of a numberMathGoogle Sheets
- AGGREGATEReturns an aggregate in a list or databaseMathNo Google Sheets equivalent
- ARABICConverts a Roman number to Arabic, as a numberMathGoogle Sheets
- ASINReturns the arcsine of a numberMathGoogle Sheets
- ASINHReturns the inverse hyperbolic sine of a numberMathGoogle Sheets
- ATANReturns the arctangent of a numberMathGoogle Sheets
- ATAN2Returns the arctangent from x- and y-coordinatesMathGoogle Sheets
- ATANHReturns the inverse hyperbolic tangent of a numberMathGoogle Sheets
- BASEConverts a number into a text representation with the given radix (base)MathGoogle Sheets
- CEILING.MATHRounds a number up, to the nearest integer or to the nearest multiple of significanceMathGoogle Sheets
- CEILING.PRECISERounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.MathGoogle Sheets
- COMBINReturns the number of combinations for a given number of objectsMathGoogle Sheets
- COMBINAReturns the number of combinations with repetitions for a given number of itemsMathGoogle Sheets
- COSReturns the cosine of a numberMathGoogle Sheets
- COSHReturns the hyperbolic cosine of a numberMathGoogle Sheets
- COTReturns the hyperbolic cosine of a numberMathGoogle Sheets
- COTHReturns the cotangent of an angleMathGoogle Sheets
- CSCReturns the cosecant of an angleMathGoogle Sheets
- CSCHReturns the hyperbolic cosecant of an angleMathGoogle Sheets
- DECIMALConverts a text representation of a number in a given base into a decimal numberMathGoogle Sheets
- DEGREESConverts radians to degreesMathGoogle Sheets
- EVENRounds a number up to the nearest even integerMathGoogle Sheets
- EXPReturns e raised to the power of a given numberMathGoogle Sheets
- FACTReturns the factorial of a numberMathGoogle Sheets
- FACTDOUBLEReturns the double factorial of a numberMathGoogle Sheets
- FLOOR.MATHRounds a number down, to the nearest integer or to the nearest multiple of significanceMathGoogle Sheets
- FLOOR.PRECISERounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.MathGoogle Sheets
- GCDReturns the greatest common divisorMathGoogle Sheets
- INTRounds a number down to the nearest integerMathGoogle Sheets
- ISO.CEILINGReturns a number that is rounded up to the nearest integer or to the nearest multiple of significanceMathGoogle Sheets
- LCMReturns the least common multipleMathGoogle Sheets
- LNReturns the natural logarithm of a numberMathGoogle Sheets
- LOGReturns the logarithm of a number to a specified baseMathGoogle Sheets
- LOG10Returns the base-10 logarithm of a numberMathGoogle Sheets
- MDETERMReturns the matrix determinant of an arrayMathGoogle Sheets
- MINVERSEReturns the matrix inverse of an arrayMathGoogle Sheets
- MMULTReturns the matrix product of two arraysMathGoogle Sheets
- MODReturns the remainder from divisionMathGoogle Sheets
- MROUNDReturns a number rounded to the desired multipleMathGoogle Sheets
- MULTINOMIALReturns the multinomial of a set of numbersMathGoogle Sheets
- MUNITReturns the unit matrix or the specified dimensionMathGoogle Sheets
- ODDRounds a number up to the nearest odd integerMathGoogle Sheets
- PERCENTOFSums the values in the subset and divides it by all the valuesMathNo Google Sheets equivalent
- PIReturns the value of piMathGoogle Sheets
- POWERReturns the result of a number raised to a powerMathGoogle Sheets
- PRODUCTMultiplies its argumentsMathGoogle Sheets
- QUOTIENTReturns the integer portion of a divisionMathGoogle Sheets
- RADIANSConverts degrees to radiansMathGoogle Sheets
- RANDReturns a random number between 0 and 1MathGoogle Sheets
- RANDARRAYReturns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values.MathGoogle Sheets
- RANDBETWEENReturns a random number between the numbers you specifyMathGoogle Sheets
- ROMANConverts an arabic numeral to roman, as textMathGoogle Sheets
- ROUNDRounds a number to a specified number of digitsMathGoogle Sheets
- ROUNDDOWNRounds a number down, toward zeroMathGoogle Sheets
- ROUNDUPRounds a number up, away from zeroMathGoogle Sheets
- SECReturns the secant of an angleMathGoogle Sheets
- SECHReturns the hyperbolic secant of an angleMathGoogle Sheets
- SEQUENCEGenerates a list of sequential numbers in an array, such as 1, 2, 3, 4MathGoogle Sheets
- SERIESSUMReturns the sum of a power series based on the formulaMathGoogle Sheets
- SIGNReturns the sign of a numberMathGoogle Sheets
- SINReturns the sine of the given angleMathGoogle Sheets
- SINHReturns the hyperbolic sine of a numberMathGoogle Sheets
- SQRTReturns a positive square rootMathGoogle Sheets
- SQRTPIReturns the square root of (number * pi)MathGoogle Sheets
- SUBTOTALReturns a subtotal in a list or databaseMathGoogle Sheets
- SUMAdds its argumentsMathGoogle Sheets
- SUMIFAdds the cells specified by a given criteriaMathGoogle Sheets
- SUMIFSAdds the cells in a range that meet multiple criteriaMathGoogle Sheets
- SUMPRODUCTReturns the sum of the products of corresponding array componentsMathGoogle Sheets
- SUMSQReturns the sum of the squares of the argumentsMathGoogle Sheets
- SUMX2MY2Returns the sum of the difference of squares of corresponding values in two arraysMathGoogle Sheets
- SUMX2PY2Returns the sum of the sum of squares of corresponding values in two arraysMathGoogle Sheets
- SUMXMY2Returns the sum of squares of differences of corresponding values in two arraysMathGoogle Sheets
- TANReturns the tangent of a numberMathGoogle Sheets
- TANHReturns the hyperbolic tangent of a numberMathGoogle Sheets
- TRUNCTruncates a number to an integerMathGoogle Sheets
Excel financial functions
Financial — 55 functions and counting.
- ACCRINTReturns the accrued interest for a security that pays periodic interestFinancialGoogle Sheets
- ACCRINTMReturns the accrued interest for a security that pays interest at maturityFinancialGoogle Sheets
- AMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficientFinancialNo Google Sheets equivalent
- AMORLINCReturns the depreciation for each accounting periodFinancialGoogle Sheets
- COUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement dateFinancialGoogle Sheets
- COUPDAYSReturns the number of days in the coupon period that contains the settlement dateFinancialGoogle Sheets
- COUPDAYSNCReturns the number of days from the settlement date to the next coupon dateFinancialGoogle Sheets
- COUPNCDReturns the next coupon date after the settlement dateFinancialGoogle Sheets
- COUPNUMReturns the number of coupons payable between the settlement date and maturity dateFinancialGoogle Sheets
- COUPPCDReturns the previous coupon date before the settlement dateFinancialGoogle Sheets
- CUMIPMTReturns the cumulative interest paid between two periodsFinancialGoogle Sheets
- CUMPRINCReturns the cumulative principal paid on a loan between two periodsFinancialGoogle Sheets
- DBReturns the depreciation of an asset for a specified period by using the fixed-declining balance methodFinancialGoogle Sheets
- DDBReturns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specifyFinancialGoogle Sheets
- DISCReturns the discount rate for a securityFinancialGoogle Sheets
- DOLLARDEConverts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal numberFinancialGoogle Sheets
- DOLLARFRConverts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fractionFinancialGoogle Sheets
- DURATIONReturns the annual duration of a security with periodic interest paymentsFinancialGoogle Sheets
- EFFECTReturns the effective annual interest rateFinancialGoogle Sheets
- FVReturns the future value of an investmentFinancialGoogle Sheets
- FVSCHEDULEReturns the future value of an initial principal after applying a series of compound interest ratesFinancialGoogle Sheets
- INTRATEReturns the interest rate for a fully invested securityFinancialGoogle Sheets
- IPMTReturns the interest payment for an investment for a given periodFinancialGoogle Sheets
- IRRReturns the internal rate of return for a series of cash flowsFinancialGoogle Sheets
- ISPMTCalculates the interest paid during a specific period of an investmentFinancialGoogle Sheets
- MDURATIONReturns the Macauley modified duration for a security with an assumed par value of $100FinancialGoogle Sheets
- MIRRReturns the internal rate of return where positive and negative cash flows are financed at different ratesFinancialGoogle Sheets
- NOMINALReturns the annual nominal interest rateFinancialGoogle Sheets
- NPERReturns the number of periods for an investmentFinancialGoogle Sheets
- NPVReturns the net present value of an investment based on a series of periodic cash flows and a discount rateFinancialGoogle Sheets
- ODDFPRICEReturns the price per $100 face value of a security with an odd first periodFinancialNo Google Sheets equivalent
- ODDFYIELDReturns the yield of a security with an odd first periodFinancialNo Google Sheets equivalent
- ODDLPRICEReturns the price per $100 face value of a security with an odd last periodFinancialNo Google Sheets equivalent
- ODDLYIELDReturns the yield of a security with an odd last periodFinancialNo Google Sheets equivalent
- PDURATIONReturns the number of periods required by an investment to reach a specified valueFinancialGoogle Sheets
- PMTReturns the periodic payment for an annuityFinancialGoogle Sheets
- PPMTReturns the payment on the principal for an investment for a given periodFinancialGoogle Sheets
- PRICEReturns the price per $100 face value of a security that pays periodic interestFinancialGoogle Sheets
- PRICEDISCReturns the price per $100 face value of a discounted securityFinancialGoogle Sheets
- PRICEMATReturns the price per $100 face value of a security that pays interest at maturityFinancialGoogle Sheets
- PVReturns the present value of an investmentFinancialGoogle Sheets
- RATEReturns the interest rate per period of an annuityFinancialGoogle Sheets
- RECEIVEDReturns the amount received at maturity for a fully invested securityFinancialGoogle Sheets
- RRIReturns an equivalent interest rate for the growth of an investmentFinancialGoogle Sheets
- SLNReturns the straight-line depreciation of an asset for one periodFinancialGoogle Sheets
- SYDReturns the sum-of-years' digits depreciation of an asset for a specified periodFinancialGoogle Sheets
- TBILLEQReturns the bond-equivalent yield for a Treasury billFinancialGoogle Sheets
- TBILLPRICEReturns the price per $100 face value for a Treasury billFinancialGoogle Sheets
- TBILLYIELDReturns the yield for a Treasury billFinancialGoogle Sheets
- VDBReturns the depreciation of an asset for a specified or partial period by using a declining balance methodFinancialGoogle Sheets
- XIRRReturns the internal rate of return for a schedule of cash flows that is not necessarily periodicFinancialGoogle Sheets
- XNPVReturns the net present value for a schedule of cash flows that is not necessarily periodicFinancialGoogle Sheets
- YIELDReturns the yield on a security that pays periodic interestFinancialGoogle Sheets
- YIELDDISCReturns the annual yield for a discounted security; for example, a Treasury billFinancialGoogle Sheets
- YIELDMATReturns the annual yield of a security that pays interest at maturityFinancialGoogle Sheets
Excel lookup functions
Lookup — 40 functions and counting.
- ADDRESSReturns a reference as text to a single cell in a worksheetLookupGoogle Sheets
- AREASReturns the number of areas in a referenceLookupNo Google Sheets equivalent
- CHOOSEChooses a value from a list of valuesLookupGoogle Sheets
- CHOOSECOLSReturns the specified columns from an arrayLookupGoogle Sheets
- CHOOSEROWSReturns the specified rows from an arrayLookupGoogle Sheets
- COLUMNReturns the column number of a referenceLookupGoogle Sheets
- COLUMNSReturns the number of columns in a referenceLookupGoogle Sheets
- DROPExcludes a specified number of rows or columns from the start or end of an arrayLookupNo Google Sheets equivalent
- EXPANDExpands or pads an array to specified row and column dimensionsLookupNo Google Sheets equivalent
- FILTERFilters a range of data based on criteria you defineLookupGoogle Sheets
- FORMULATEXTReturns the formula at the given reference as textLookupGoogle Sheets
- GETPIVOTDATAReturns data stored in a PivotTable reportLookupGoogle Sheets
- GROUPBYHelps a user group, aggregate, sort, and filter data based on the fields you specifyLookupNo Google Sheets equivalent
- HLOOKUPLooks in the top row of an array and returns the value of the indicated cellLookupGoogle Sheets
- HSTACKAppends arrays horizontally and in sequence to return a larger arrayLookupGoogle Sheets
- HYPERLINKCreates a shortcut or jump that opens a document stored on a network server, an intranet, or the InternetLookupGoogle Sheets
- IMAGEReturns an image from a given sourceLookupGoogle Sheets
- INDEXUses an index to choose a value from a reference or arrayLookupGoogle Sheets
- INDIRECTReturns a reference indicated by a text valueLookupGoogle Sheets
- LOOKUPLooks up values in a vector or arrayLookupGoogle Sheets
- MATCHLooks up values in a reference or arrayLookupGoogle Sheets
- OFFSETReturns a reference offset from a given referenceLookupGoogle Sheets
- PIVOTBYHelps a user group, aggregate, sort, and filter data based on the row and column fields that you specifyLookupNo Google Sheets equivalent
- ROWReturns the row number of a referenceLookupGoogle Sheets
- ROWSReturns the number of rows in a referenceLookupGoogle Sheets
- RTDRetrieves real-time data from a program that supports COM automationLookupNo Google Sheets equivalent
- SORTSorts the contents of a range or arrayLookupGoogle Sheets
- SORTBYSorts the contents of a range or array based on the values in a corresponding range or arrayLookupNo Google Sheets equivalent
- TAKEReturns a specified number of contiguous rows or columns from the start or end of an arrayLookupNo Google Sheets equivalent
- TOCOLReturns the array in a single columnLookupGoogle Sheets
- TOROWReturns the array in a single rowLookupGoogle Sheets
- TRANSPOSEReturns the transpose of an arrayLookupGoogle Sheets
- TRIMRANGEScans in from the edges of a range or array until it finds a non-blank cell (or value), it then excludes those blank rows or columnsLookupNo Google Sheets equivalent
- UNIQUEReturns a list of unique values in a list or rangeLookupGoogle Sheets
- VLOOKUPLooks in the first column of an array and moves across the row to return the value of a cellLookupGoogle Sheets
- VSTACKAppends arrays vertically and in sequence to return a larger arrayLookupGoogle Sheets
- WRAPCOLSWraps the provided row or column of values by columns after a specified number of elementsLookupGoogle Sheets
- WRAPROWSWraps the provided row or column of values by rows after a specified number of elementsLookupGoogle Sheets
- XLOOKUPSearches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.LookupGoogle Sheets
- XMATCHReturns the relative position of an item in an array or range of cells.LookupGoogle Sheets
Excel text functions
Text — 38 functions and counting.
- ARRAYTOTEXTReturns an array of text values from any specified rangeTextNo Google Sheets equivalent
- CHARReturns the character specified by the code numberTextGoogle Sheets
- CLEANRemoves all nonprintable characters from textTextGoogle Sheets
- CODEReturns a numeric code for the first character in a text stringTextGoogle Sheets
- CONCATCombines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.TextGoogle Sheets
- CONCATENATEJoins several text items into one text itemTextGoogle Sheets
- DETECTLANGUAGEIdentifies the language of a specified textTextGoogle Sheets
- DOLLARConverts a number to text, using the $ (dollar) currency formatTextGoogle Sheets
- EXACTChecks to see if two text values are identicalTextGoogle Sheets
- FINDFinds one text value within another (case-sensitive)TextGoogle Sheets
- FIXEDFormats a number as text with a fixed number of decimalsTextGoogle Sheets
- LEFTReturns the leftmost characters from a text valueTextGoogle Sheets
- LENReturns the number of characters in a text stringTextGoogle Sheets
- LOWERConverts text to lowercaseTextGoogle Sheets
- MIDReturns a specific number of characters from a text string starting at the position you specifyTextGoogle Sheets
- NUMBERVALUEConverts text to number in a locale-independent mannerTextNo Google Sheets equivalent
- PROPERCapitalizes the first letter in each word of a text valueTextGoogle Sheets
- REGEXEXTRACTExtracts strings within the provided text that matches the patternTextGoogle Sheets
- REGEXREPLACEReplaces strings within the provided text that matches the pattern with replacementTextGoogle Sheets
- REGEXTESTDetermines whether any part of text matches the patternTextNo Google Sheets equivalent
- REPLACEReplaces characters within textTextGoogle Sheets
- REPTRepeats text a given number of timesTextGoogle Sheets
- RIGHTReturns the rightmost characters from a text valueTextGoogle Sheets
- SEARCHFinds one text value within another (not case-sensitive)TextGoogle Sheets
- SUBSTITUTESubstitutes new text for old text in a text stringTextGoogle Sheets
- TConverts its arguments to textTextGoogle Sheets
- TEXTFormats a number and converts it to textTextGoogle Sheets
- TEXTAFTERReturns text that occurs after given character or stringTextNo Google Sheets equivalent
- TEXTBEFOREReturns text that occurs before a given character or stringTextNo Google Sheets equivalent
- TEXTJOINCombines the text from multiple ranges and/or stringsTextGoogle Sheets
- TEXTSPLITSplits text strings by using column and row delimitersTextNo Google Sheets equivalent
- TRANSLATETranslates a text from one language to anotherTextNo Google Sheets equivalent
- TRIMRemoves spaces from textTextGoogle Sheets
- UNICHARReturns the Unicode character that is references by the given numeric valueTextGoogle Sheets
- UNICODEReturns the number (code point) that corresponds to the first character of the textTextGoogle Sheets
- UPPERConverts text to uppercaseTextGoogle Sheets
- VALUEConverts a text argument to a numberTextGoogle Sheets
- VALUETOTEXTReturns text from any specified valueTextNo Google Sheets equivalent
Excel date functions
Date — 25 functions and counting.
- DATEReturns the serial number of a particular dateDateGoogle Sheets
- DATEDIFCalculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.DateGoogle Sheets
- DATEVALUEConverts a date in the form of text to a serial numberDateGoogle Sheets
- DAYConverts a serial number to a day of the monthDateGoogle Sheets
- DAYSReturns the number of days between two datesDateGoogle Sheets
- DAYS360Calculates the number of days between two dates based on a 360-day yearDateGoogle Sheets
- EDATEReturns the serial number of the date that is the indicated number of months before or after the start dateDateGoogle Sheets
- EOMONTHReturns the serial number of the last day of the month before or after a specified number of monthsDateGoogle Sheets
- HOURConverts a serial number to an hourDateGoogle Sheets
- ISOWEEKNUMReturns the number of the ISO week number of the year for a given dateDateGoogle Sheets
- MINUTEConverts a serial number to a minuteDateGoogle Sheets
- MONTHConverts a serial number to a monthDateGoogle Sheets
- NETWORKDAYSReturns the number of whole workdays between two datesDateGoogle Sheets
- NETWORKDAYS.INTLReturns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend daysDateGoogle Sheets
- NOWReturns the serial number of the current date and timeDateGoogle Sheets
- SECONDConverts a serial number to a secondDateGoogle Sheets
- TIMEReturns the serial number of a particular timeDateGoogle Sheets
- TIMEVALUEConverts a time in the form of text to a serial numberDateGoogle Sheets
- TODAYReturns the serial number of today's dateDateGoogle Sheets
- WEEKDAYConverts a serial number to a day of the weekDateGoogle Sheets
- WEEKNUMConverts a serial number to a number representing where the week falls numerically with a yearDateGoogle Sheets
- WORKDAYReturns the serial number of the date before or after a specified number of workdaysDateGoogle Sheets
- WORKDAY.INTLReturns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend daysDateGoogle Sheets
- YEARConverts a serial number to a yearDateGoogle Sheets
- YEARFRACReturns the year fraction representing the number of whole days between start_date and end_dateDateGoogle Sheets
Excel info functions
Info — 22 functions and counting.
- CELLReturns information about the formatting, location, or contents of a cellThis function is not available in Excel for the web.InfoGoogle Sheets
- ERROR.TYPEReturns a number corresponding to an error typeInfoGoogle Sheets
- INFOReturns information about the current operating environmentThis function is not available in Excel for the web.InfoNo Google Sheets equivalent
- ISBLANKReturns TRUE if the value is blankInfoGoogle Sheets
- ISERRReturns TRUE if the value is any error value except #N/AInfoGoogle Sheets
- ISERRORReturns TRUE if the value is any error valueInfoGoogle Sheets
- ISEVENReturns TRUE if the number is evenInfoGoogle Sheets
- ISFORMULAReturns TRUE if there is a reference to a cell that contains a formulaInfoGoogle Sheets
- ISLOGICALReturns TRUE if the value is a logical valueInfoGoogle Sheets
- ISNAReturns TRUE if the value is the #N/A error valueInfoGoogle Sheets
- ISNONTEXTReturns TRUE if the value is not textInfoGoogle Sheets
- ISNUMBERReturns TRUE if the value is a numberInfoGoogle Sheets
- ISODDReturns TRUE if the number is oddInfoGoogle Sheets
- ISOMITTEDChecks whether the value in a LAMBDA is missing and returns TRUE or FALSEInfoNo Google Sheets equivalent
- ISREFReturns TRUE if the value is a referenceInfoGoogle Sheets
- ISTEXTReturns TRUE if the value is textInfoGoogle Sheets
- NReturns a value converted to a numberInfoGoogle Sheets
- NAReturns the error value #N/AInfoGoogle Sheets
- SHEETReturns the sheet number of the referenced sheetInfoGoogle Sheets
- SHEETSReturns the number of sheets in a referenceInfoGoogle Sheets
- STOCKHISTORYRetrieves historical data about a financial instrument and loads it as an arrayInfoNo Google Sheets equivalent
- TYPEReturns a number indicating the data type of a valueInfoGoogle Sheets
Excel logical functions
Logical — 19 functions and counting.
- ANDReturns TRUE if all of its arguments are TRUELogicalGoogle Sheets
- BYCOLApplies a LAMBDA to each column and returns an array of the resultsLogicalGoogle Sheets
- BYROWApplies a LAMBDA to each row and returns an array of the resultsLogicalGoogle Sheets
- FALSEReturns the logical value FALSELogicalGoogle Sheets
- IFSpecifies a logical test to performLogicalGoogle Sheets
- IFERRORReturns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formulaLogicalGoogle Sheets
- IFNAReturns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expressionLogicalGoogle Sheets
- IFSChecks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.LogicalGoogle Sheets
- LAMBDACreate custom, reusable and call them by a friendly nameLogicalGoogle Sheets
- LETAssigns names to calculation resultsLogicalGoogle Sheets
- MAKEARRAYReturns a calculated array of a specified row and column size, by applying a LAMBDALogicalGoogle Sheets
- MAPReturns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new valueLogicalGoogle Sheets
- NOTReverses the logic of its argumentLogicalGoogle Sheets
- ORReturns TRUE if any argument is TRUELogicalGoogle Sheets
- REDUCEReduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulatorLogicalGoogle Sheets
- SCANScans an array by applying a LAMBDA to each value and returns an array that has each intermediate valueLogicalGoogle Sheets
- SWITCHEvaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.LogicalGoogle Sheets
- TRUEReturns the logical value TRUELogicalGoogle Sheets
- XORReturns a logical exclusive OR of all argumentsLogicalGoogle Sheets
Excel database functions
Database — 12 functions and counting.
- DAVERAGEReturns the average of selected database entriesDatabaseGoogle Sheets
- DCOUNTCounts the cells that contain numbers in a databaseDatabaseGoogle Sheets
- DCOUNTACounts nonblank cells in a databaseDatabaseGoogle Sheets
- DGETExtracts from a database a single record that matches the specified criteriaDatabaseGoogle Sheets
- DMAXReturns the maximum value from selected database entriesDatabaseGoogle Sheets
- DMINReturns the minimum value from selected database entriesDatabaseGoogle Sheets
- DPRODUCTMultiplies the values in a particular field of records that match the criteria in a databaseDatabaseGoogle Sheets
- DSTDEVEstimates the standard deviation based on a sample of selected database entriesDatabaseGoogle Sheets
- DSTDEVPCalculates the standard deviation based on the entire population of selected database entriesDatabaseGoogle Sheets
- DSUMAdds the numbers in the field column of records in the database that match the criteriaDatabaseGoogle Sheets
- DVAREstimates variance based on a sample from selected database entriesDatabaseGoogle Sheets
- DVARPCalculates variance based on the entire population of selected database entriesDatabaseGoogle Sheets
Excel statistical functions
Statistical — 8 functions and counting.
- AVERAGEIFReturns the average (arithmetic mean) of all the cells in a range that meet a given criteriaStatisticalGoogle Sheets
- COUNTBLANKCounts the number of blank cells within a rangeStatisticalGoogle Sheets
- COUNTIFCounts the number of cells within a range that meet the given criteriaStatisticalGoogle Sheets
- COUNTIFSCounts the number of cells within a range that meet multiple criteriaStatisticalGoogle Sheets
- FORECAST.LINEARReturns a future value based on existing valuesStatisticalGoogle Sheets
- GAMMALNReturns the natural logarithm of the gamma function, Γ(x)StatisticalGoogle Sheets
- GAMMALN.PRECISEReturns the natural logarithm of the gamma function, Γ(x)StatisticalGoogle Sheets
- LINESTReturns the parameters of a linear trendStatisticalGoogle Sheets
Excel engineering functions
Engineering — 5 functions and counting.
- ERFCReturns the complementary error functionEngineeringGoogle Sheets
- ERFC.PRECISEReturns the complementary ERF function integrated between x and infinityEngineeringGoogle Sheets
- IMLNReturns the natural logarithm of a complex numberEngineeringGoogle Sheets
- IMPOWERReturns a complex number raised to an integer powerEngineeringGoogle Sheets
- IMSQRTReturns the square root of a complex numberEngineeringGoogle Sheets
Excel compatibility functions
Compatibility — 3 functions and counting.
Excel web functions
Web — 3 functions and counting.
- ENCODEURLReturns a URL-encoded stringThis function is not available in Excel for the web.WebGoogle Sheets
- FILTERXMLReturns specific data from the XML content by using the specified XPathThis function is not available in Excel for the web.WebNo Google Sheets equivalent
- WEBSERVICEReturns data from a web service.This function is not available in Excel for the web.WebNo Google Sheets equivalent