Google Sheets function reference
Every function, explained with examples you can edit live.
294 of Google Sheets’s 516 functions so far — syntax, realistic worked examples, and the Excel equivalent for each. New functions land every week.
Looking for Excel?Google Sheets math functions
Math — 84 functions and counting.
- ABSReturns the absolute value of a number.MathExcel
- ACOSReturns the inverse cosine of a value, in radians.MathExcel
- ACOSHReturns the inverse hyperbolic cosine of a number.MathExcel
- ACOTReturns the inverse cotangent of a value, in radians. .MathExcel
- ACOTHReturns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive..MathExcel
- ASINReturns the inverse sine of a value, in radians.MathExcel
- ASINHReturns the inverse hyperbolic sine of a number.MathExcel
- ATANReturns the inverse tangent of a value, in radians.MathExcel
- ATAN2Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (`x`,`y`), in radians.MathExcel
- ATANHReturns the inverse hyperbolic tangent of a number.MathExcel
- BASEConverts a number into a text representation in another base, for example, base 2 for binary. .MathExcel
- CEILINGRounds a number up to the nearest integer multiple of specified significance.MathExcel
- CEILING.MATHRounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode.MathExcel
- CEILING.PRECISERounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up.MathExcel
- COMBINReturns the number of ways to choose some number of objects from a pool of a given size of objects.MathExcel
- COMBINAReturns the number of ways to choose some number of objects from a pool of a given size of objects, including ways that choose the same object multiple times. .MathExcel
- COSReturns the cosine of an angle provided in radians.MathExcel
- COSHReturns the hyperbolic cosine of any real number.MathExcel
- COTCotangent of an angle provided in radians. .MathExcel
- COTHReturns the hyperbolic cotangent of any real number. .MathExcel
- COUNTBLANKReturns the number of empty cells in a given range.MathExcel
- COUNTIFReturns a conditional count across a range.MathExcel
- COUNTIFSReturns the count of a range depending on multiple criteria.MathExcel
- COUNTUNIQUECounts the number of unique values in a list of specified values and ranges.MathNo Excel equivalent
- CSCReturns the cosecant of an angle provided in radians. .MathExcel
- CSCHThe CSCH function returns the hyperbolic cosecant of any real number. .MathExcel
- DECIMALThe DECIMAL function converts the text representation of a number in another base, to base 10 (decimal). .MathExcel
- DEGREESConverts an angle value in radians to degrees.MathExcel
- ERFCReturns the complementary Gauss error function of a value.MathExcel
- ERFC.PRECISESeeMathExcel
- EVENRounds a number up to the nearest even integer.MathExcel
- EXPReturns Euler's number, e (~2.718) raised to a power.MathExcel
- FACTReturns the factorial of a number.MathExcel
- FACTDOUBLEReturns the "double factorial" of a number.MathExcel
- FLOORRounds a number down to the nearest integer multiple of specified significance.MathExcel
- FLOOR.MATHRounds a number down to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode.MathExcel
- FLOOR.PRECISEThe FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance. .MathExcel
- GAMMALNReturns the the logarithm of a specified Gamma function, base e (Euler's number).MathExcel
- GAMMALN.PRECISESeeMathExcel
- GCDReturns the greatest common divisor of one or more integers.MathExcel
- IMLNReturns the logarithm of a complex number, base e (Euler's number).MathExcel
- IMPOWERReturns a complex number raised to a power.MathExcel
- IMSQRTComputes the square root of a complex number.MathExcel
- INTRounds a number down to the nearest integer that is less than or equal to it.MathExcel
- ISEVENChecks whether the provided value is even.MathExcel
- ISO.CEILINGSeeMathExcel
- ISODDChecks whether the provided value is odd.MathExcel
- LCMReturns the least common multiple of one or more integers.MathExcel
- LNReturns the the logarithm of a number, base e (Euler's number).MathExcel
- LOGReturns the the logarithm of a number given a base.MathExcel
- LOG10Returns the the logarithm of a number, base 10.MathExcel
- MODReturns the result of the modulo operator, the remainder after a division operation.MathExcel
- MROUNDRounds one number to the nearest integer multiple of another.MathExcel
- MULTINOMIALReturns the factorial of the sum of values divided by the product of the values' factorials.MathExcel
- MUNITReturns a unit matrix of size dimension x dimension. .MathExcel
- ODDRounds a number up to the nearest odd integer.MathExcel
- PIReturns the value of Pi to 14 decimal places.MathExcel
- POWERReturns a number raised to a power.MathExcel
- PRODUCTReturns the result of multiplying a series of numbers together.MathExcel
- QUOTIENTReturns one number divided by another.MathExcel
- RADIANSConverts an angle value in degrees to radians.MathExcel
- RANDReturns a random number between 0 inclusive and 1 exclusive.MathExcel
- RANDARRAYGenerates an array of random numbers between 0 and 1. .MathExcel
- RANDBETWEENReturns a uniformly random integer between two values, inclusive.MathExcel
- ROUNDRounds a number to a certain number of decimal places according to standard rules.MathExcel
- ROUNDDOWNRounds a number to a certain number of decimal places, always rounding down to the next valid increment.MathExcel
- ROUNDUPRounds a number to a certain number of decimal places, always rounding up to the next valid increment.MathExcel
- SECThe SEC function returns the secant of an angle, measured in radians. .MathExcel
- SECHThe SECH function returns the hyperbolic secant of an angle.MathExcel
- SEQUENCEReturns an array of sequential numbers, such as 1, 2, 3, 4. .MathExcel
- SERIESSUMGiven parameters x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range `a`.MathExcel
- SIGNGiven an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.MathExcel
- SINReturns the sine of an angle provided in radians.MathExcel
- SINHReturns the hyperbolic sine of any real number.MathExcel
- SQRTReturns the positive square root of a positive number.MathExcel
- SQRTPIReturns the positive square root of the product of Pi and the given positive number.MathExcel
- SUBTOTALReturns a subtotal for a vertical range of cells using a specified aggregation function.MathExcel
- SUMReturns the sum of a series of numbers and/or cells.MathExcel
- SUMIFReturns a conditional sum across a range.MathExcel
- SUMIFSReturns the sum of a range depending on multiple criteria.MathExcel
- SUMSQReturns the sum of the squares of a series of numbers and/or cells.MathExcel
- TANReturns the tangent of an angle provided in radians.MathExcel
- TANHReturns the hyperbolic tangent of any real number.MathExcel
- TRUNCTruncates a number to a certain number of significant digits by omitting less significant digits.MathExcel
Google Sheets financial functions
Financial — 50 functions and counting.
- ACCRINTCalculates the accrued interest of a security that has periodic payments.FinancialExcel
- ACCRINTMCalculates the accrued interest of a security that pays interest at maturity.FinancialExcel
- AMORLINCReturns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.FinancialExcel
- COUPDAYBSCalculates the number of days from the first coupon, or interest payment, until settlement.FinancialExcel
- COUPDAYSCalculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.FinancialExcel
- COUPDAYSNCCalculates the number of days from the settlement date until the next coupon, or interest payment.FinancialExcel
- COUPNCDCalculates next coupon, or interest payment, date after the settlement date.FinancialExcel
- COUPNUMCalculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment.FinancialExcel
- COUPPCDCalculates last coupon, or interest payment, date before the settlement date.FinancialExcel
- CUMIPMTCalculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- CUMPRINCCalculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- DBCalculates the depreciation of an asset for a specified period using the arithmetic declining balance method.FinancialExcel
- DDBCalculates the depreciation of an asset for a specified period using the double-declining balance method.FinancialExcel
- DISCCalculates the discount rate of a security based on price.FinancialExcel
- DOLLARDEConverts a price quotation given as a decimal fraction into a decimal value.FinancialExcel
- DOLLARFRConverts a price quotation given as a decimal value into a decimal fraction.FinancialExcel
- DURATIONCalculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value.FinancialExcel
- EFFECTCalculates the annual effective interest rate given the nominal rate and number of compounding periods per year.FinancialExcel
- FVCalculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- FVSCHEDULECalculates the future value of some principal based on a specified series of potentially varying interest rates.FinancialExcel
- INTRATECalculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself.FinancialExcel
- IPMTCalculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- IRRCalculates the internal rate of return on an investment based on a series of periodic cash flows.FinancialExcel
- ISPMTThe ISPMT function calculates the interest paid during a particular period of an investment. .FinancialExcel
- MDURATIONCalculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.FinancialExcel
- MIRRCalculates the modified internal rate of return on an investment based on a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income.FinancialExcel
- NOMINALCalculates the annual nominal interest rate given the effective rate and number of compounding periods per year.FinancialExcel
- NPERCalculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- NPVCalculates the net present value of an investment based on a series of periodic cash flows and a discount rate.FinancialExcel
- PDURATIONReturns the number of periods for an investment to reach a specific value at a given rate. .FinancialExcel
- PMTCalculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- PPMTCalculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- PRICECalculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.FinancialExcel
- PRICEDISCCalculates the price of a discount (non-interest-bearing) security, based on expected yield.FinancialExcel
- PRICEMATCalculates the price of a security paying interest at maturity, based on expected yield.FinancialExcel
- PVCalculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- RATECalculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate.FinancialExcel
- RECEIVEDCalculates the amount received at maturity for an investment in fixed-income securities purchased on a given date.FinancialExcel
- RRIReturns the interest rate needed for an investment to reach a specific value within a given number of periods. .FinancialExcel
- SLNCalculates the depreciation of an asset for one period using the straight-line method.FinancialExcel
- SYDCalculates the depreciation of an asset for a specified period using the sum of years digits method.FinancialExcel
- TBILLEQCalculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.FinancialExcel
- TBILLPRICECalculates the price of a US Treasury Bill based on discount rate.FinancialExcel
- TBILLYIELDCalculates the yield of a US Treasury Bill based on price.FinancialExcel
- VDBReturns the depreciation of an asset for a particular period (or partial period). .FinancialExcel
- XIRRCalculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows.FinancialExcel
- XNPVCalculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate.FinancialExcel
- YIELDCalculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price.FinancialExcel
- YIELDDISCCalculates the annual yield of a discount (non-interest-bearing) security, based on price.FinancialExcel
- YIELDMATCalculates the annual yield of a security paying interest at maturity, based on price.FinancialExcel
Google Sheets text functions
Text — 33 functions and counting.
- ARABICComputes the value of a Roman numeral.TextExcel
- CHARConvert a number into a character according to the current Unicode table.TextExcel
- CLEANReturns the text with the non-printable ASCII characters removed.TextExcel
- CODEReturns the numeric Unicode map value of the first character in the string provided.TextExcel
- CONCATENATEAppends strings to one another.TextExcel
- DOLLARFormats a number into the locale-specific currency format.TextExcel
- EXACTTests whether two strings are identical.TextExcel
- FINDReturns the position at which a string is first found within text.TextExcel
- FIXEDFormats a number with a fixed number of decimal places.TextExcel
- JOINConcatenates the elements of one or more one-dimensional arrays using a specified delimiter.TextNo Excel equivalent
- LEFTReturns a substring from the beginning of a specified string.TextExcel
- LENReturns the length of a string.TextExcel
- LOWERConverts a specified string to lowercase.TextExcel
- MIDReturns a segment of a string.TextExcel
- PROPERCapitalizes each word in a specified string.TextExcel
- REGEXEXTRACTExtracts matching substrings according to a regular expression.TextExcel
- REGEXMATCHWhether a piece of text matches a regular expression.TextNo Excel equivalent
- REGEXREPLACEReplaces part of a text string with a different text string using regular expressions.TextExcel
- REPLACEReplaces part of a text string with a different text string.TextExcel
- REPTReturns specified text repeated a number of times.TextExcel
- RIGHTReturns a substring from the end of a specified string.TextExcel
- ROMANFormats a number in Roman numerals.TextExcel
- SEARCHReturns the position at which a string is first found within text.TextExcel
- SPLITDivides text around a specified character or string, and puts each fragment into a separate cell in the row.TextNo Excel equivalent
- SUBSTITUTEReplaces existing text with new text in a string.TextExcel
- TReturns string arguments as text.TextExcel
- TEXTConverts a number into text according to a specified format.TextExcel
- TEXTJOINCombines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.TextExcel
- TRIMRemoves leading and trailing spaces in a specified string.TextExcel
- UNICHARReturns the Unicode character for a number. .TextExcel
- UNICODEReturns the decimal Unicode value of the first character of the text.TextExcel
- UPPERConverts a specified string to uppercase.TextExcel
- VALUEConverts a string in any of the date, time or number formats that Google Sheets understands into a number.TextExcel
Google Sheets date functions
Date — 26 functions and counting.
- DATEConverts a provided year, month, and day into a date.DateExcel
- DATEDIFCalculates the number of days, months, or years between two dates.DateExcel
- DATEVALUEConverts a provided date string in a known format to a date value.DateExcel
- DAYReturns the day of the month that a specific date falls on, in numeric format.DateExcel
- DAYSReturns the number of days between two dates.DateExcel
- DAYS360Returns the difference between two days based on the 360 day year used in some financial interest calculations.DateExcel
- EDATEReturns a date a specified number of months before or after another date.DateExcel
- EOMONTHReturns a date representing the last day of a month which falls a specified number of months before or after another date.DateExcel
- EPOCHTODATEConverts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC.DateNo Excel equivalent
- HOURReturns the hour component of a specific time, in numeric format.DateExcel
- ISOWEEKNUMReturns the number of the ISO week of the year where the provided date falls.DateExcel
- MINUTEReturns the minute component of a specific time, in numeric format.DateExcel
- MONTHReturns the month of the year a specific date falls in, in numeric format.DateExcel
- NETWORKDAYSReturns the number of net working days between two provided days.DateExcel
- NETWORKDAYS.INTLReturns the number of net working days between two provided days excluding specified weekend days and holidays.DateExcel
- NOWReturns the current date and time as a date value.DateExcel
- SECONDReturns the second component of a specific time, in numeric format.DateExcel
- TIMEConverts a provided hour, minute, and second into a time.DateExcel
- TIMEVALUEReturns the fraction of a 24-hour day the time represents.DateExcel
- TODAYReturns the current date as a date value.DateExcel
- WEEKDAYReturns a number representing the day of the week of the date provided.DateExcel
- WEEKNUMReturns a number representing the week of the year where the provided date falls.DateExcel
- WORKDAYCalculates the end date after a specified number of working days.DateExcel
- WORKDAY.INTLCalculates the date after a specified number of workdays excluding specified weekend days and holidays.DateExcel
- YEARReturns the year specified by a given date.DateExcel
- YEARFRACReturns the number of years, including fractional years, between two dates using a specified day count convention.DateExcel
Google Sheets array functions
Array — 23 functions and counting.
- BYCOLGroups an array by columns by application of a LAMBDA function to each column.ArrayExcel
- BYROWGroups an array by rows by application of a LAMBDA function to each row.ArrayExcel
- CHOOSECOLSCreates a new array from the selected columns in the existing range.ArrayExcel
- CHOOSEROWSCreates a new array from the selected rows in the existing range.ArrayExcel
- HSTACKAppends ranges horizontally and in sequence to return a larger array.ArrayExcel
- LINESTGiven partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method.ArrayExcel
- MAKEARRAYReturns an array of specified dimensions with values calculated by application of a LAMBDA function.ArrayExcel
- MAPMaps each value in the given arrays to a new value by application of a LAMBDA function to each value.ArrayExcel
- MDETERMReturns the matrix determinant of a square matrix specified as an array or range.ArrayExcel
- MINVERSEReturns the multiplicative inverse of a square matrix specified as an array or range.ArrayExcel
- MMULTCalculates the matrix product of two matrices specified as arrays or ranges.ArrayExcel
- REDUCEReduces an array to an accumulated result by application of a LAMBDA function to each value.ArrayExcel
- SCANScans an array and produces intermediate values by application of a LAMBDA function to each value. Returns an array of the intermediate values obtained at each step.ArrayExcel
- SUMPRODUCTCalculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.ArrayExcel
- SUMX2MY2Calculates the sum of the differences of the squares of values in two arrays.ArrayExcel
- SUMX2PY2Calculates the sum of the sums of the squares of values in two arrays.ArrayExcel
- SUMXMY2Calculates the sum of the squares of differences of values in two arrays.ArrayExcel
- TOCOLTransforms an array or range of cells into a single column.ArrayExcel
- TOROWTransforms an array or range of cells into a single row.ArrayExcel
- TRANSPOSETransposes the rows and columns of an array or range of cells.ArrayExcel
- VSTACKAppends ranges vertically and in sequence to return a larger array.ArrayExcel
- WRAPCOLSWraps the provided row or column of cells by columns after a specified number of elements to form a new array.ArrayExcel
- WRAPROWSWraps the provided row or column of cells by rows after a specified number of elements to form a new array.ArrayExcel
Google Sheets info functions
Info — 18 functions and counting.
- CELLReturns the requested information about the specified cell.InfoExcel
- ERROR.TYPEReturns a number corresponding to the error value in a different cell.InfoExcel
- ISBLANKChecks whether the referenced cell is empty.InfoExcel
- ISDATEReturns whether a value is a date.InfoNo Excel equivalent
- ISEMAILChecks whether a value is a valid email address.InfoNo Excel equivalent
- ISERRChecks whether a value is an error other than `#N/A`.InfoExcel
- ISERRORChecks whether a value is an error.InfoExcel
- ISFORMULAChecks whether a formula is in the referenced cell.InfoExcel
- ISLOGICALChecks whether a value is `TRUE` or `FALSE`.InfoExcel
- ISNAChecks whether a value is the error `#N/A`.InfoExcel
- ISNONTEXTChecks whether a value is non-textual.InfoExcel
- ISNUMBERChecks whether a value is a number.InfoExcel
- ISREFChecks whether a value is a valid cell reference.InfoExcel
- ISTEXTChecks whether a value is text.InfoExcel
- NReturns the argument provided as a number.InfoExcel
- NAReturns the "value not available" error, `#N/A`.InfoExcel
- SHEETSReturns the total number of sheets in the referenced spreadsheet. .InfoExcel
- TYPEReturns a number associated with the type of data passed into the function.InfoExcel
Google Sheets lookup functions
Lookup — 18 functions and counting.
- ADDRESSReturns a cell reference as a string.LookupExcel
- CHOOSEReturns an element from a list of choices based on index.LookupExcel
- COLUMNReturns the column number of a specified cell, with `A=1`.LookupExcel
- COLUMNSReturns the number of columns in a specified array or range.LookupExcel
- FORMULATEXTReturns the formula as a string. .LookupExcel
- GETPIVOTDATAExtracts an aggregated value from a pivot table that corresponds to the specified row and column headings.LookupExcel
- HLOOKUPHorizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found.LookupExcel
- INDEXReturns the content of a cell, specified by row and column offset.LookupExcel
- INDIRECTReturns a cell reference specified by a string.LookupExcel
- LOOKUPLooks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column.LookupExcel
- MATCHReturns the relative position of an item in a range that matches a specified value.LookupExcel
- OFFSETReturns a range reference shifted a specified number of rows and columns from a starting cell reference.LookupExcel
- ROWReturns the row number of a specified cell.LookupExcel
- ROWSReturns the number of rows in a specified array or range.LookupExcel
- SHEETReturns the sheet number of the specified sheet or other reference. .LookupExcel
- VLOOKUPVertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.LookupExcel
- XLOOKUPReturns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match.LookupExcel
- XMATCHReturns the relative position of an item in an array or range that matches a specified value.LookupExcel
Google Sheets logical functions
Logical — 13 functions and counting.
- ANDReturns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.LogicalExcel
- FALSEReturns the logical value `FALSE`.LogicalExcel
- IFReturns one value if a logical expression is `TRUE` and another if it is `FALSE`.LogicalExcel
- IFERRORReturns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.LogicalExcel
- IFNAEvaluates a value. If the value is an #N/A error, returns the specified value. .LogicalExcel
- IFSEvaluates multiple conditions and returns a value that corresponds to the first true condition.LogicalExcel
- LAMBDACreates and returns a custom function with a set of names and a formula_expression that uses them. To calculate the formula_expression, you can call the returned function with as many values as the name declares.LogicalExcel
- LETAssigns name with the value_expression results and returns the result of the formula_expression. The formula_expression can use the names defined in the scope of the LET function. The value_expressions are evaluated only once in the LET function even if the following value_expressions or the formula_expression use them multiple times.LogicalExcel
- NOTReturns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.LogicalExcel
- ORReturns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.LogicalExcel
- SWITCHTests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met.LogicalExcel
- TRUEReturns the logical value `TRUE`.LogicalExcel
- XORThe XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise. .LogicalExcel
Google Sheets database functions
Database — 12 functions and counting.
- DAVERAGEReturns the average of a set of values selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DCOUNTCounts numeric values selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DCOUNTACounts values, including text, selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DGETReturns a single value from a database table-like array or range using a SQL-like query.DatabaseExcel
- DMAXReturns the maximum value selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DMINReturns the minimum value selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DPRODUCTReturns the product of values selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DSTDEVReturns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DSTDEVPReturns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DSUMReturns the sum of values selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DVARReturns the variance of a population sample selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DVARPReturns the variance of an entire population selected from a database table-like array or range using a SQL-like query.DatabaseExcel
Google Sheets web functions
Web — 8 functions and counting.
- ENCODEURLEncodes a string of text for the purpose of using in a URL query. .WebExcel
- HYPERLINKCreates a hyperlink inside a cell.WebExcel
- IMPORTDATAImports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.WebNo Excel equivalent
- IMPORTFEEDImports a RSS or ATOM feed.WebNo Excel equivalent
- IMPORTHTMLImports data from a table or list within an HTML page.WebNo Excel equivalent
- IMPORTRANGEImports a range of cells from a specified spreadsheet.WebNo Excel equivalent
- IMPORTXMLImports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.WebNo Excel equivalent
- ISURLChecks whether a value is a valid URL.WebNo Excel equivalent
Google Sheets statistical functions
Statistical — 3 functions and counting.
Google Sheets filter functions
Filter — 2 functions and counting.
Google Sheets google functions
Google — 2 functions and counting.
Google Sheets operator functions
Operator — 2 functions and counting.