Google spreadsheets function list
Google Spreadsheets supports cell formulas typically found in most desktop spreadsheet packages. These formulas can be used to create functions that manipulate data and calculate strings and numbers.
Here's a list of all the functions available in each category. When using them, don't forget to add quotation marks around all function components made of alphabetic characters that aren't referring to cells or columns.
The new Google Sheets includes a number of additional functions. These functions include ARRAY_CONSTRAIN
, ARRAY_LITERAL
, ARRAY_ROW
, CELL
, CLEAN
, DELTA
, ISEMAIL
, ISURL
, TIMEVALUE
, LOOKUP
, PERCENTRANK.EXC
, PERCENTRANK.INC
, RANK.AVG
, RANK.EQ
, TYPE
, WEEKNUM
, SUMIFS
, COUNTIFS
, AVERAGEIF
, AVERAGEIFS
, NETWORKDAYS.INTL
, WORKDAY.INTL
, SEARCHB
, FINDB
, and TDIST
.
Type  Name  Syntax  Description 

Date  DATE  DATE(year, month, day)  Converts a provided year, month, and day into a date. Learn more 
Date  DATEVALUE  DATEVALUE(date_string)  Converts a provided date string in a known format to a date value. Learn more 
Date  DAY  DAY(date)  Returns the day of the month that a specific date falls on, in numeric format. Learn more 
Date  DAYS360  DAYS360(start_date, end_date, method)  Returns the difference between two days based on the 360 day year used in some financial interest calculations. Learn more 
Date  EDATE  EDATE(start_date)  Returns a date a specified number of months before or after another date. Learn more 
Date  EOMONTH  EOMONTH(start_date, months)  Returns a date representing the last day of a month which falls a specified number of months before or after another date. Learn more 
Date  HOUR  HOUR(time)  Returns the hour component of a specific time, in numeric format. Learn more 
Date  MINUTE  MINUTE(time)  Returns the minute component of a specific time, in numeric format. Learn more 
Date  MONTH  MONTH(date)  Returns the month of the year a specific date falls in, in numeric format. Learn more 
Date  NETWORKDAYS  NETWORKDAYS(start_date, end_date, holidays)  Returns the number of net working days between two provided days. Learn more 
Date  NETWORKDAYS.INTL  NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])  Returns the number of net working days between two provided days excluding specified weekend days and holidays. Only available in the new Google Sheets. Learn more 
Date  NOW  NOW()  Returns the current date and time as a date value. Learn more 
Date  SECOND  SECOND(time)  Returns the second component of a specific time, in numeric format. Learn more 
Date  TIME  TIME(hour, minute, second)  Converts a provided hour, minute, and second into a time. Learn more 
Date  TIMEVALUE  TIMEVALUE(time_string)  Returns the fraction of a 24hour day the time represents. Only available in the new Google Sheets. Learn more 
Date  TODAY  TODAY()  Returns the current date as a date value. Learn more 
Date  WEEKDAY  WEEKDAY(date, type)  Returns a number representing the day of the week of the date provided. Learn more 
Date  WEEKNUM  WEEKNUM(date, [type])  Returns a number representing the week of the year where the provided date falls. Only available in the new Google Sheets. Learn more 
Date  WORKDAY  WORKDAY(start_date, num_days, holidays)  Calculates the number of working days from a specified start date. Learn more 
Date  WORKDAY.INTL  WORKDAY.INTL(start_date, num_days, [weekend], [holidays])  Calculates the date after a specified number of workdays excluding specified weekend days and holidays. Only available in the new Google Sheets. Learn more 
Date  YEAR  YEAR(date)  Returns the year specified by a given date. Learn more 
Date  YEARFRAC  YEARFRAC(start_date, end_date, day_count_convention)  Returns the number of years, including fractional years, between two dates using a specified day count convention. Learn more 
Engineering  BIN2DEC  BIN2DEC(signed_binary_number)  Converts a signed binary number to decimal format. Learn more 
Engineering  BIN2HEX  BIN2HEX(signed_binary_number, significant_digits)  Converts a signed binary number to signed hexadecimal format. Learn more 
Engineering  BIN2OCT  BIN2OCT(signed_binary_number, significant_digits)  Converts a signed binary number to signed octal format. Learn more 
Engineering  DEC2BIN  DEC2BIN(decimal_number, significant_digits)  Converts a decimal number to signed binary format. Learn more 
Engineering  DEC2HEX  DEC2HEX(decimal_number, significant_digits)  Converts a decimal number to signed hexadecimal format. Learn more 
Engineering  DEC2OCT  DEC2OCT(decimal_number, significant_digits)  Converts a decimal number to signed octal format. Learn more 
Engineering  DELTA  DELTA(number1, [number2])  Compare two numeric values, returning 1 if they're equal. Only available in the new Google Sheets. Learn more 
Engineering  HEX2BIN  HEX2BIN(signed_hexadecimal_number, significant_digits)  Converts a signed hexadecimal number to signed binary format. Learn more 
Engineering  HEX2DEC  HEX2DEC(signed_hexadecimal_number)  Converts a signed hexadecimal number to decimal format. Learn more 
Engineering  HEX2OCT  HEX2OCT(signed_hexadecimal_number, significant_digits)  Converts a signed hexadecimal number to signed octal format. Learn more 
Engineering  OCT2BIN  OCT2BIN(signed_octal_number, significant_digits)  Converts a signed octal number to signed binary format. Learn more 
Engineering  OCT2DEC  OCT2DEC(signed_octal_number)  Converts a signed octal number to decimal format. Learn more 
Engineering  OCT2HEX  OCT2HEX(signed_octal_number, significant_digits)  Converts a signed octal number to signed hexadecimal format. Learn more 
Filter  FILTER  FILTER(range, condition1, condition2)  Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions. Learn more 
Filter  SORT  SORT(range, sort_column, is_ascending, sort_column2, is_ascending2)  Sorts the rows of a given array or range by the values in one or more columns. Learn more 
Filter  UNIQUE  UNIQUE(range)  Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range. Learn more 
Financial  ACCRINT  ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, day_count_convention)  Calculates the accrued interest of a security that has periodic payments. Learn more 
Financial  ACCRINTM  ACCRINTM(issue, maturity, rate, redemption, day_count_convention)  Calculates the accrued interest of a security that pays interest at maturity. Learn more 
Financial  COUPDAYBS  COUPDAYBS(settlement, maturity, frequency, day_count_convention)  Calculates the number of days from the first coupon, or interest payment, until settlement. Learn more 
Financial  COUPDAYS  COUPDAYS(settlement, maturity, frequency, day_count_convention)  Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date. Learn more 
Financial  COUPDAYSNC  COUPDAYSNC(settlement, maturity, frequency, day_count_convention)  Calculates the number of days from the settlement date until the next coupon, or interest payment. Learn more 
Financial  COUPNCD  COUPNCD(settlement, maturity, frequency, day_count_convention)  Calculates next coupon, or interest payment, date after the settlement date. Learn more 
Financial  COUPNUM  COUPNUM(settlement, maturity, frequency, day_count_convention)  Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment. Learn more 
Financial  COUPPCD  COUPPCD(settlement, maturity, frequency, day_count_convention)  Calculates last coupon, or interest payment, date before the settlement date. Learn more 
Financial  CUMIPMT  CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)  Calculates the cumulative interest over a range of payment periods for an investment based on constantamount periodic payments and a constant interest rate. Learn more 
Financial  CUMPRINC  CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)  Calculates the cumulative principal paid over a range of payment periods for an investment based on constantamount periodic payments and a constant interest rate. Learn more 
Financial  DB  DB(cost, salvage, life, period, month)  Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method. Learn more 
Financial  DDB  DDB(cost, salvage, life, period, factor)  Calculates the depreciation of an asset for a specified period using the doubledeclining balance method. Learn more 
Financial  DISC  DISC(settlement, maturity, price, redemption, day_count_convention)  Calculates the discount rate of a security based on price. Learn more 
Financial  DOLLARDE  DOLLARDE(fractional_price, unit)  Converts a price quotation given as a decimal fraction into a decimal value. Learn more 
Financial  DOLLARFR  DOLLARFR(decimal_price, unit)  Converts a price quotation given as a decimal value into a decimal fraction. Learn more 
Financial  DURATION  DURATION(rate, present_value, future_value)  Calculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value. Learn more 
Financial  EFFECT  EFFECT(nominal_rate, periods_per_year)  Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year. Learn more 
Financial  FV  FV(rate, number_of_periods, payment_amount, present_value, end_or_beginning)  Calculates the future value of an annuity investment based on constantamount periodic payments and a constant interest rate. Learn more 
Financial  FVSCHEDULE  FVSCHEDULE(principal, rate_schedule)  Calculates the future value of some principal based on a specified series of potentially varying interest rates. Learn more 
Financial  INTRATE  INTRATE(buy_date, sell_date, buy_price, sell_price, day_count_convention)  Calculates 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. Learn more 
Financial  IPMT  IPMT(rate, period, number_of_periods, present_value, future_value, end_or_beginning)  Calculates the payment on interest for an investment based on constantamount periodic payments and a constant interest rate. Learn more 
Financial  IRR  IRR(cashflow_amounts, rate_guess)  Calculates the internal rate of return on an investment based on a series of periodic cash flows. Learn more 
Financial  MDURATION  MDURATION(settlement, maturity, rate, yield, frequency, day_count_convention)  Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more 
Financial  MIRR  MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)  Calculates 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. Learn more 
Financial  NOMINAL  NOMINAL(effective_rate, periods_per_year)  Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year. Learn more 
Financial  NPER  NPER(rate, payment_amount, present_value, future_value, end_or_beginning)  Calculates the number of payment periods for an investment based on constantamount periodic payments and a constant interest rate. Learn more 
Financial  NPV  NPV(discount, cashflow1, cashflow2)  Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate. Learn more 
Financial  PMT  PMT(rate, number_of_periods, present_value, future_value, end_or_beginning)  Calculates the periodic payment for an annuity investment based on constantamount periodic payments and a constant interest rate. Learn more 
Financial  PPMT  PPMT(rate, period, number_of_periods, present_value, future_value, end_or_beginning)  Calculates the payment on the principal of an investment based on constantamount periodic payments and a constant interest rate. Learn more 
Financial  PRICE  PRICE(settlement, maturity, rate, yield, redemption, frequency, day_count_convention)  Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more 
Financial  PRICEDISC  PRICEDISC(settlement, maturity, discount, redemption, day_count_convention)  Calculates the price of a discount (noninterestbearing) security, based on expected yield. Learn more 
Financial  PRICEMAT  PRICEMAT(settlement, maturity, issue, rate, yield, day_count_convention)  Calculates the price of a security paying interest at maturity, based on expected yield. Learn more 
Financial  PV  PV(rate, number_of_periods, payment_amount, future_value, end_or_beginning)  Calculates the present value of an annuity investment based on constantamount periodic payments and a constant interest rate. Learn more 
Financial  RATE  RATE(number_of_periods, payment_per_period, present_value, future_value, end_or_beginning, rate_guess)  Calculates the interest rate of an annuity investment based on constantamount periodic payments and the assumption of a constant interest rate. Learn more 
Financial  RECEIVED  RECEIVED(settlement, maturity, investment, discount, day_count_convention)  Calculates the amount received at maturity for an investment in fixedincome securities purchased on a given date. Learn more 
Financial  SLN  SLN(cost, salvage, life)  Calculates the depreciation of an asset for one period using the straightline method. Learn more 
Financial  SYD  SYD(cost, salvage, life, period)  Calculates the depreciation of an asset for a specified period using the sum of years digits method. Learn more 
Financial  TBILLEQ  TBILLEQ(settlement, maturity, discount)  Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate. Learn more 
Financial  TBILLPRICE  TBILLPRICE(settlement, maturity, discount)  Calculates the price of a US Treasury Bill based on discount rate. Learn more 
Financial  TBILLYIELD  TBILLYIELD(settlement, maturity, price)  Calculates the yield of a US Treasury Bill based on price. Learn more 
Financial  XIRR  XIRR(cashflow_amounts, cashflow_dates, rate_guess)  Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows. Learn more 
Financial  XNPV  XNPV(discount, cashflow_amounts, cashflow_dates)  Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate. Learn more 
Financial  YIELD  YIELD(settlement, maturity, rate, price, redemption, frequency, day_count_convention)  Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price. Learn more 
Financial  YIELDDISC  YIELDDISC(settlement, maturity, price, redemption, day_count_convention)  Calculates the annual yield of a discount (noninterestbearing) security, based on price. Learn more 
ARRAYFORMULA  ARRAYFORMULA(array_formula)  Enables the display of values returned from an array formula into multiple rows and/or columns and the use of nonarray functions with arrays. Learn more  
CONTINUE  CONTINUE(source_cell, row, column)  Returns a specified cell from an array formula result. Learn more  
DETECTLANGUAGE  DETECTLANGUAGE(text_or_range)  Identifies the language used in text within the specified range. Learn more  
GOOGLECLOCK  GOOGLECLOCK()  Returns the current system date and time and updates automatically once per minute. Learn more  
GOOGLEFINANCE  GOOGLEFINANCE(ticker, attribute, start_date, end_datenum_days, interval)  Fetches current or historical securities information from Google Finance. Learn more  
GOOGLETOURNAMENT  GOOGLETOURNAMENT(year, league, round, game_slot, statistic, team)  Returns data for March Madness (NCAA Division I Basketball Championship) games. Learn more  
GOOGLETRANSLATE  GOOGLETRANSLATE(text, source_language, target_language)  Translates text from one language into another/ Learn more  
IMAGE  IMAGE(url, mode)  Inserts an image into a cell. Learn more  
IMPORTDATA  IMPORTDATA(url)  Imports data at a given url in .csv (commaseparated value) or .tsv (tabseparated value) format. Learn more  
IMPORTFEED  IMPORTFEED(url, query, headers, num_items)  Imports a RSS or ATOM feed. Learn more  
IMPORTHTML  IMPORTHTML(url, query, index)  Imports data from a table or list within an HTML page. Learn more  
IMPORTRANGE  IMPORTRANGE(spreadsheet_key, range_string)  Imports a range of cells from a specified spreadsheet. Learn more  
IMPORTXML  IMPORTXML(url, xpath_query)  Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. Learn more  
QUERY  QUERY(data, query, headers)  Runs a Google Visualization API Query Language query across data. Learn more  
SPARKLINE  SPARKLINE(data, options)  Creates a miniature chart contained within a single cell. Learn more  
GoogleLookup  GoogleLookup(entity, attribute)  The GoogleLookup function was retired in November 2011. This function relied on technology from Google Squared, a Google Lab that has been shut down. As a result, the GoogleLookup function can no longer be used, and cells that contain GoogleLookup functions will return an error.  
Info  ERROR.TYPE  ERROR.TYPE(reference)  Returns a number corresponding to the error value in a different cell. Learn more 
Info  ISBLANK  ISBLANK(value)  Checks whether the referenced cell is empty. Learn more 
Info  ISEMAIL  ISEMAIL(value)  Checks whether a value is a valid email address. Only available in the new Google Sheets. Learn more 
Info  ISERR  ISERR(value)  Checks whether a value is an error other than `#N/A`. Learn more 
Info  ISERROR  ISERROR(value)  Checks whether a value is an error. Learn more 
Info  ISLOGICAL  ISLOGICAL(value)  Checks whether a value is `TRUE` or `FALSE`. Learn more 
Info  ISNA  ISNA(value)  Checks whether a value is the error `#N/A`. Learn more 
Info  ISNONTEXT  ISNONTEXT(value)  Checks whether a value is nontextual. Learn more 
Info  ISNUMBER  ISNUMBER(value)  Checks whether a value is a number. Learn more 
Info  ISREF  ISREF(value)  Checks whether a value is a valid cell reference. Learn more 
Info  ISTEXT  ISTEXT(value)  Checks whether a value is text. Learn more 
Info  N  N(value)  Returns the argument provided as a number. Learn more 
Info  NA  NA()  Returns the "value not available" error, `#N/A`. Learn more 
Info  TYPE  TYPE(value)  Returns a number associated with the type of data passed into the function. Only available in the new Google Sheets. Learn more 
Info  CELL  CELL(info_type, reference)  Returns the requested information about the specified cell. Only available in the new Google Sheets. Learn more 
Info  ISURL  ISURL(value)  Checks whether a value is a valid URL. Only available in the new Google Sheets. Learn more 
Logical  AND  AND(logical_expression1, logical_expression2)  Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. Learn more 
Logical  FALSE  FALSE()  Returns the logical value `FALSE`. Learn more 
Logical  IF  IF(logical_expression, value_if_true, value_if_false)  Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. Learn more 
Logical  IFERROR  IFERROR(value, value_if_error)  Returns 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. Learn more 
Logical  NOT  NOT(logical_expression)  Returns the opposite of a logical value  `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`. Learn more 
Logical  OR  OR(logical_expression1, logical_expression2)  Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false. Learn more 
Logical  TRUE  TRUE()  Returns the logical value `TRUE`. Learn more 
Lookup  ADDRESS  ADDRESS(row, column, absolute_relative_mode, use_a1_notation, sheet)  Returns a cell reference as a string. Learn more 
Lookup  CHOOSE  CHOOSE(index, choice1, choice2)  Returns an element from a list of choices based on index. Learn more 
Lookup  COLUMN  COLUMN(cell_reference)  Returns the column number of a specified cell, with `A=1`. Learn more 
Lookup  COLUMNS  COLUMNS(range)  Returns the number of columns in a specified array or range. Learn more 
Lookup  HLOOKUP  HLOOKUP(search_key, range, index, is_sorted)  Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found. Learn more 
Lookup  HYPERLINK  HYPERLINK(url, link_label)  Creates a hyperlink inside a cell. Learn more 
Lookup  INDEX  INDEX(reference, row, column)  Returns the content of a cell, specified by row and column offset. Learn more 
Lookup  INDIRECT  INDIRECT(cell_reference_as_string)  Returns a cell reference specified by a string. Learn more 
Lookup  LOOKUP  LOOKUP(search_key, search_rangesearch_result_array, [result_range])  Looks 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. Only available in the new Google Sheets. Learn more 
Lookup  MATCH  MATCH(search_key, range, search_type)  Returns the relative position of an item in a range that matches a specified value. Learn more 
Lookup  OFFSET  OFFSET(cell_reference, offset_rows, offset_columns, height, width)  Returns a range reference shifted a specified number of rows and columns from a starting cell reference. Learn more 
Lookup  ROW  ROW(cell_reference)  Returns the row number of a specified cell. Learn more 
Lookup  ROWS  ROWS(range)  Returns the number of rows in a specified array or range. Learn more 
Lookup  VLOOKUP  VLOOKUP(search_key, range, index, is_sorted)  Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found. Learn more 
Math  ABS  ABS(value)  Returns the absolute value of a number. Learn more 
Math  ACOS  ACOS(value)  Returns the inverse cosine of a value, in radians. Learn more 
Math  ACOSH  ACOSH(value)  Returns the inverse hyperbolic cosine of a number. Learn more 
Math  ASIN  ASIN(value)  Returns the inverse sine of a value, in radians. Learn more 
Math  ASINH  ASINH(value)  Returns the inverse hyperbolic sine of a number. Learn more 
Math  ATAN  ATAN(value)  Returns the inverse tangent of a value, in radians. Learn more 
Math  ATAN2  ATAN2(x, y)  Returns the angle between the xaxis and a line segment from the origin (0,0) to specified coordinate pair (`x`,`y`), in radians. Learn more 
Math  ATANH  ATANH(value)  Returns the inverse hyperbolic tangent of a number. Learn more 
Math  CEILING  CEILING(value, factor)  Rounds a number up to the nearest integer multiple of specified significance. Learn more 
Math  COMBIN  COMBIN(n, k)  Returns the number of ways to choose some number of objects from a pool of a given size of objects. Learn more 
Math  COS  COS(angle)  Returns the cosine of an angle provided in radians. Learn more 
Math  COSH  COSH(value)  Returns the hyperbolic cosine of any real number. Learn more 
Math  COUNTBLANK  COUNTBLANK(range)  Returns the number of empty cells in a given range. Learn more 
Math  COUNTIF  COUNTIF(range, criterion)  Returns a conditional count across a range. Learn more 
Math  COUNTIFS  COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])  Returns the count of a range depending on multiple criteria. Only available in the new Google Sheets. Learn more 
Math  COUNTUNIQUE  COUNTUNIQUE(value1, value2)  Counts the number of unique values in a list of specified values and ranges. Learn more 
Math  DEGREES  DEGREES(angle)  Converts an angle value in radians to degrees. Learn more 
Math  ERFC  ERFC(z)  Returns the complementary Gauss error function of a value. Learn more 
Math  EVEN  EVEN(value)  Rounds a number up to the nearest even integer. Learn more 
Math  EXP  EXP(exponent)  Returns Euler's number, e (~2.718) raised to a power. Learn more 
Math  FACT  FACT(value)  Returns the factorial of a number. Learn more 
Math  FACTDOUBLE  FACTDOUBLE(value)  Returns the "double factorial" of a number. Learn more 
Math  FLOOR  FLOOR(value, factor)  Rounds a number down to the nearest integer multiple of specified significance. Learn more 
Math  GAMMALN  GAMMALN(value)  Returns the the logarithm of a specified Gamma function, base e (Euler's number). Learn more 
Math  GCD  GCD(value1, value2)  Returns the greatest common divisor of one or more integers. Learn more 
Math  INT  INT(value)  Rounds a number down to the nearest integer that is less than or equal to it. Learn more 
Math  ISEVEN  ISEVEN(value)  Checks whether the provided value is even. Learn more 
Math  ISODD  ISODD(value)  Checks whether the provided value is odd. Learn more 
Math  LCM  LCM(value1, value2)  Returns the least common multiple of one or more integers. Learn more 
Math  LN  LN(value)  Returns the the logarithm of a number, base e (Euler's number). Learn more 
Math  LOG  LOG(value, base)  Returns the the logarithm of a number given a base. Learn more 
Math  LOG10  LOG10(value)  Returns the the logarithm of a number, base 10. Learn more 
Math  MOD  MOD(dividend, divisor)  Returns the result of the modulo operator, the remainder after a division operation. Learn more 
Math  MROUND  MROUND(value, factor)  Rounds one number to the nearest integer multiple of another. Learn more 
Math  MULTINOMIAL  MULTINOMIAL(value1, value2)  Returns the factorial of the sum of values divided by the product of the values' factorials. Learn more 
Math  ODD  ODD(value)  Rounds a number up to the nearest odd integer. Learn more 
Math  PI  PI()  Returns the value of Pi to 14 decimal places. Learn more 
Math  POWER  POWER(base, exponent)  Returns a number raised to a power. Learn more 
Math  PRODUCT  PRODUCT(factor1, factor2)  Returns the result of multiplying a series of numbers together. Learn more 
Math  QUOTIENT  QUOTIENT(dividend, divisor)  Returns one number divided by another. Learn more 
Math  RADIANS  RADIANS(angle)  Converts an angle value in degrees to radians. Learn more 
Math  RAND  RAND()  Returns a random number between 0 inclusive and 1 exclusive. Learn more 
Math  RANDBETWEEN  RANDBETWEEN(low, high)  Returns a uniformly random integer between two values, inclusive. Learn more 
Math  ROUND  ROUND(value, places)  Rounds a number to a certain number of decimal places according to standard rules. Learn more 
Math  ROUNDDOWN  ROUNDDOWN(value, places)  Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. Learn more 
Math  ROUNDUP  ROUNDUP(value, places)  Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. Learn more 
Math  SERIESSUM  SERIESSUM(x, n, m, a) 
Given parameters x , n , m , and a , returns the power series sum a_{1}x^{n} + a_{2}x^{(n+m)} + ... + a_{i}x^{(n+(i1)m)}, where i is the number of entries in range `a`. Learn more

Math  SIGN  SIGN(value)  Given an input number, returns `1` if it is negative, `1` if positive, and `0` if it is zero. Learn more 
Math  SIN  SIN(angle)  Returns the sine of an angle provided in radians. Learn more 
Math  SINH  SINH(value)  Returns the hyperbolic sine of any real number. Learn more 
Math  SQRT  SQRT(value)  Returns the positive square root of a positive number. Learn more 
Math  SQRTPI  SQRTPI(value)  Returns the positive square root of the product of Pi and the given positive number. Learn more 
Math  SUBTOTAL  SUBTOTAL(function_code, range1, range2)  Returns a subtotal for a vertical range of cells using a specified aggregation function. Learn more 
Math  SUM  SUM(value1, value2)  Returns the sum of a series of numbers and/or cells. Learn more 
Math  SUMIF  SUMIF(range, criterion, sum_range)  Returns a conditional sum across a range. Learn more 
Math  SUMIFS  SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])  Returns the sum of a range depending on multiple criteria. Only available in the new Google Sheets. Learn more 
Math  SUMSQ  SUMSQ(value1, value2)  Returns the sum of the squares of a series of numbers and/or cells. Learn more 
Math  TAN  TAN(angle)  Returns the tangent of an angle provided in radians. Learn more 
Math  TANH  TANH(value)  Returns the hyperbolic tangent of any real number. Learn more 
Math  TRUNC  TRUNC(value, places)  Truncates a number to a certain number of significant digits by omitting less significant digits. Learn more 
Operator  ADD  ADD(value1, value2)  Returns the sum of two numbers. Equivalent to the `+` operator. Learn more 
Operator  CONCAT  CONCAT(value1, value2)  Returns the concatenation of two values. Equivalent to the `&` operator. Learn more 
Operator  DIVIDE  DIVIDE(dividend, divisor)  Returns one number divided by another. Equivalent to the `/` operator. Learn more 
Operator  EQ  EQ(value1, value2)  Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `==` operator. Learn more 
Operator  GT  GT(value1, value2)  Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator. Learn more 
Operator  GTE  GTE(value1, value2)  Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator. Learn more 
Operator  LT  LT(value1, value2)  Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator. Learn more 
Operator  LTE  LTE(value1, value2)  Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator. Learn more 
Operator  MINUS  MINUS(value1, value2)  Returns the difference of two numbers. Equivalent to the `` operator. Learn more 
Operator  MULTIPLY  MULTIPLY(factor1, factor2)  Returns the product of two numbers. Equivalent to the `*` operator. Learn more 
Operator  NE  NE(value1, value2)  Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `!=` operator. Learn more 
Operator  POW  POW(base, exponent)  Returns a number raised to a power. Learn more 
Operator  UMINUS  UMINUS(value)  Returns a number with the sign reversed. Learn more 
Operator  UNARY_PERCENT  UNARY_PERCENT(percentage)  Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`. Learn more 
Operator  UPLUS  UPLUS(value)  Returns a specified number, unchanged.. Learn more 
Statistical  AVEDEV  AVEDEV(value1, value2)  Calculates the average of the magnitudes of deviations of data from a dataset's mean. Learn more 
Statistical  AVERAGE  AVERAGE(value1, value2)  Returns the numerical average value in a dataset, ignoring text. Learn more 
Statistical  AVERAGEA  AVERAGEA(value1, value2)  Returns the numerical average value in a dataset. Learn more 
Statistical  AVERAGEIF  AVERAGEIF(criteria_range, criterion, [average_range])  Returns the average of a range depending on criteria. Only available in the new Google Sheets. Learn more 
Statistical  AVERAGEIFS  AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])  Returns the average of a range depending on multiple criteria. Only available in the new Google Sheets. Learn more 
Statistical  BINOMDIST  BINOMDIST(num_successes, num_trials, prob_success, cumulative)  Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws. Learn more 
Statistical  CONFIDENCE  CONFIDENCE(alpha, standard_deviation, pop_size)  Calculates the width of half the confidence interval for a normal distribution. Learn more 
Statistical  CORREL  CORREL(data_y, data_x)  Calculates r, the Pearson productmoment correlation coefficient of a dataset. Learn more 
Statistical  COUNT  COUNT(value1, value2)  Returns the a count of the number of numeric values in a dataset. Learn more 
Statistical  COUNTA  COUNTA(value1, value2)  Returns the a count of the number of values in a dataset. Learn more 
Statistical  COVAR  COVAR(data_y, data_x)  Calculates the covariance of a dataset. Learn more 
Statistical  CRITBINOM  CRITBINOM(num_trials, prob_success, target_prob)  Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria. Learn more 
Statistical  DEVSQ  DEVSQ(value1, value2)  Calculates the sum of squares of deviations based on a sample. Learn more 
Statistical  EXPONDIST  EXPONDIST(x, lambda, cumulative)  Returns the value of the exponential distribution function with a specified lambda at a specified value. Learn more 
Statistical  FISHER  FISHER(value)  Returns the Fisher transformation of a specified value. Learn more 
Statistical  FISHERINV  FISHERINV(value)  Returns the inverse Fisher transformation of a specified value. Learn more 
Statistical  FORECAST  FORECAST(x, data_y, data_x)  Calculates the expected yvalue for a specified x based on a linear regression of a dataset. Learn more 
Statistical  GEOMEAN  GEOMEAN(value1, value2)  Calculates the geometric mean of a dataset. Learn more 
Statistical  HARMEAN  HARMEAN(value1, value2)  Calculates the harmonic mean of a dataset. Learn more 
Statistical  HYPGEOMDIST  HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)  Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws. Learn more 
Statistical  INTERCEPT  INTERCEPT(data_y, data_x)  Calculates the yvalue at which the line resulting from linear regression of a dataset will intersect the yaxis (x=0). Learn more 
Statistical  KURT  KURT(value1, value2)  Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset. Learn more 
Statistical  LARGE  LARGE(data, n)  Returns the nth largest element from a data set, where n is userdefined. Learn more 
Statistical  LOGINV  LOGINV(x, mean, standard_deviation)  Returns the value of the inverse lognormal cumulative distribution with given mean and standard deviation at a specified value. Learn more 
Statistical  LOGNORMDIST  LOGNORMDIST(x, mean, standard_deviation)  Returns the value of the lognormal cumulative distribution with given mean and standard deviation at a specified value. Learn more 
Statistical  MAX  MAX(value1, value2)  Returns the maximum value in a numeric dataset. Learn more 
Statistical  MAXA  MAXA(value1, value2)  Returns the maximum numeric value in a dataset. Learn more 
Statistical  MEDIAN  MEDIAN(value1, value2)  Returns the median value in a numeric dataset. Learn more 
Statistical  MIN  MIN(value1, value2)  Returns the minimum value in a numeric dataset. Learn more 
Statistical  MINA  MINA(value1, value2)  Returns the minimum numeric value in a dataset. Learn more 
Statistical  MODE  MODE(value1, value2)  Returns the most commonly occurring value in a dataset. Learn more 
Statistical  NEGBINOMDIST  NEGBINOMDIST(num_failures, num_successes, prob_success)  Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials. Learn more 
Statistical  NORMDIST  NORMDIST(x, mean, standard_deviation, cumulative)  Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation. Learn more 
Statistical  NORMINV  NORMINV(x, mean, standard_deviation)  Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation. Learn more 
Statistical  NORMSDIST  NORMSDIST(x)  Returns the value of the standard normal cumulative distribution function for a specified value. Learn more 
Statistical  NORMSINV  NORMSINV(x)  Returns the value of the inverse standard normal distribution function for a specified value. Learn more 
Statistical  PEARSON  PEARSON(data_y, data_x)  Calculates r, the Pearson productmoment correlation coefficient of a dataset. Learn more 
Statistical  PERCENTILE  PERCENTILE(data, percentile)  Returns the value at a given percentile of a dataset. Learn more 
Statistical  PERCENTRANK  PERCENTRANK(data, value, [significant_digits])  Returns the percentage rank (percentile) of a specified value in a dataset. Learn more 
Statistical  PERCENTRANK.EXC  PERCENTRANK.EXC(data, value, [significant_digits])  Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset. Only available in the new Google Sheets. Learn more 
Statistical  PERCENTRANK.INC  PERCENTRANK.INC(data, value, [significant_digits])  Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset. Only available in the new Google Sheets. Learn more 
Statistical  PERMUT  PERMUT(n, k)  Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order. Learn more 
Statistical  POISSON  POISSON(x, mean, cumulative)  Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean. Learn more 
Statistical  PROB  PROB(data, probabilities, low_limit, high_limit)  Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits. Learn more 
Statistical  QUARTILE  QUARTILE(data, quartile_number)  Returns a value nearest to a specified quartile of a dataset. Learn more 
Statistical  RANK  RANK(value, data, is_ascending)  Returns the rank of a specified value in a dataset. Learn more 
Statistical  RANK.AVG  RANK.AVG(value, data, [is_ascending])  Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned. Only available in the new Google Sheets. Learn more 
Statistical  RANK.EQ  RANK.EQ(value, data, [is_ascending])  Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned. Only available in the new Google Sheets. Learn more 
Statistical  RSQ  RSQ(data_y, data_x)  Calculates the square of r, the Pearson productmoment correlation coefficient of a dataset. Learn more 
Statistical  SKEW  SKEW(value1, value2)  Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean. Learn more 
Statistical  SLOPE  SLOPE(data_y, data_x)  Calculates the slope of the line resulting from linear regression of a dataset. Learn more 
Statistical  SMALL  SMALL(data, n)  Returns the nth smallest element from a data set, where n is userdefined. Learn more 
Statistical  STANDARDIZE  STANDARDIZE(value, mean, standard_deviation)  Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution. Learn more 
Statistical  STDEV  STDEV(value1, value2)  Calculates an estimate of standard deviation based on a sample. Learn more 
Statistical  STDEVA  STDEVA(value1, value2)  Calculates an estimate of standard deviation based on a sample, setting text to the value `0`. Learn more 
Statistical  STDEVP  STDEVP(value1, value2)  Calculates an estimate of standard deviation based on an entire population. Learn more 
Statistical  STDEVPA  STDEVPA(value1, value2)  Calculates an estimate of standard deviation based on an entire population, setting text to the value `0`. Learn more 
Statistical  STEYX  STEYX(data_y, data_x)  Calculates the standard error of the predicted yvalue for each x in the regression of a dataset. Learn more 
Statistical  TDIST  TDIST(x, degrees_freedom, tails)  Calculates the probability for Student's tdistribution with a given input (x). Only available in the new Google Sheets. Learn more 
Statistical  TRIMMEAN  TRIMMEAN(data, exclude_proportion)  Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset. Learn more 
Statistical  VAR  VAR(value1, value2)  Calculates an estimate of variance based on a sample. Learn more 
Statistical  VARA  VARA(value1, value2)  Calculates an estimate of variance based on a sample, setting text to the value `0`. Learn more 
Statistical  VARP  VARP(value1, value2)  Calculates an estimate of variance based on an entire population. Learn more 
Statistical  VARPA  VARPA(value1, value2)  Calculates an estimate of variance based on an entire population, setting text to the value `0`. Learn more 
Statistical  WEIBULL  WEIBULL(x, shape, scale, cumulative)  Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale. Learn more 
Statistical  ZTEST  ZTEST(data, value, standard_deviation)  Returns the twotailed Pvalue of a Ztest with standard distribution. Learn more 
Text  ARABIC  ARABIC(roman_numeral)  Computes the value of a Roman numeral. Learn more 
Text  CHAR  CHAR(table_number)  Convert a number into a character according to the current Unicode table. Learn more 
Text  CLEAN  CLEAN(text)  Returns the text with the nonprintable ASCII characters removed. Only available in the new Google Sheets. Learn more 
Text  CODE  CODE(string)  Returns the numeric Unicode map value of the first character in the string provided. Learn more 
Text  CONCATENATE  CONCATENATE(string1, string2)  Appends strings to one another. Learn more 
Text  DOLLAR  DOLLAR(number, number_of_places)  Formats a number into the localespecific currency format. Learn more 
Text  EXACT  EXACT(string1, string2)  Tests whether two strings are identical. Learn more 
Text  FIND  FIND(search_for, text_to_search, starting_at)  Returns the position at which a string is first found within text. Learn more 
Text  FINDB  FINDB(search_for, text_to_search, [starting_at])  Returns the position at which a string is first found within text counting each doublecharacter as 2. Only available in the new Google Sheets. Learn more 
Text  FIXED  FIXED(number, number_of_places, suppress_separator)  Formats a number with a fixed number of decimal places. Learn more 
Text  JOIN  JOIN(delimiter, value_or_array1, value_or_array2)  Concatenates the elements of one or more onedimensional arrays using a specified delimiter. Learn more 
Text  LEFT  LEFT(string, number_of_characters)  Returns a substring from the beginning of a specified string. Learn more 
Text  LEN  LEN(text)  Returns the length of a string. Learn more 
Text  LOWER  LOWER(text)  Converts a specified string to lowercase. Learn more 
Text  MID  MID(string, starting_at, extract_length)  Returns a segment of a string. Learn more 
Text  PROPER  PROPER(text_to_capitalize)  Capitalizes each word in a specified string. Learn more 
Text  REGEXEXTRACT  REGEXEXTRACT(text, regular_expression)  Extracts matching substrings according to a regular expression. Learn more 
Text  REGEXMATCH  REGEXMATCH(text, regular_expression)  Whether a piece of text matches a regular expression. Learn more 
Text  REGEXREPLACE  REGEXREPLACE(text, regular_expression, replacement)  Replaces part of a text string with a different text string using regular expressions. Learn more 
Text  REPLACE  REPLACE(text, position, length, new_text)  Replaces part of a text string with a different text string. Learn more 
Text  REPT  REPT(text_to_repeat, number_of_repetitions)  Returns specified text repeated a number of times. Learn more 
Text  RIGHT  RIGHT(string, number_of_characters)  Returns a substring from the end of a specified string. Learn more 
Text  ROMAN  ROMAN(number, rule_relaxation)  Formats a number in Roman numerals. Learn more 
Text  SEARCH  SEARCH(search_for, text_to_search, starting_at)  Returns the position at which a string is first found within text. Learn more 
Text  SEARCHB  SEARCHB(search_for, text_to_search, [starting_at])  Returns the position at which a string is first found within text counting each doublecharacter as 2. Only available in the new Google Sheets. Learn more 
Text  SPLIT  SPLIT(text, delimiter, split_by_each)  Divides text around a specified character or string, and puts each fragment into a separate cell in the row. Learn more 
Text  SUBSTITUTE  SUBSTITUTE(text_to_search, search_for, replace_with, occurrence_number)  Replaces existing text with new text in a string. Learn more 
Text  T  T(value)  Returns string arguments as text. Learn more 
Text  TEXT  TEXT(number, format)  Converts a number into text according to a specified format. Learn more 
Text  TRIM  TRIM(text)  Removes leading and trailing spaces in a specified string. Learn more 
Text  UPPER  UPPER(text)  Converts a specified string to uppercase. Learn more 
Text  VALUE  VALUE(text)  Converts a string in any of the date, time or number formats that Google Sheets understands into a number. Learn more 
Database  DAVERAGE  DAVERAGE(database, field, criteria)  Returns the average of a set of values selected from a database tablelike array or range using a SQLlike query. Learn more 
Database  DCOUNT  DCOUNT(database, field, criteria)  Counts numeric values selected from a database tablelike array or range using a SQLlike query. Learn more 
Database  DCOUNTA  DCOUNTA(database, field, criteria)  Counts values, including text, selected from a database tablelike array or range using a SQLlike query. Learn more 
Database  DGET  DGET(database, field, criteria)  Returns a single value from a database tablelike array or range using a SQLlike query. Learn more 
Database  DMAX  DMAX(database, field, criteria)  Returns the maximum value selected from a database tablelike array or range using a SQLlike query. Learn more 
Database  DMIN  DMIN(database, field, criteria)  Returns the minimum value selected from a database tablelike array or range using a SQLlike query. Learn more 
Database  DPRODUCT  DPRODUCT(database, field, criteria)  Returns the product of values selected from a database tablelike array or range using a SQLlike query. Learn more 
Database  DSTDEV  DSTDEV(database, field, criteria)  Returns the standard deviation of a population sample selected from a database tablelike array or range using a SQLlike query. Learn more 
Database  DSTDEVP  DSTDEVP(database, field, criteria)  Returns the standard deviation of an entire population selected from a database tablelike array or range using a SQLlike query. Learn more 
Database  DSUM  DSUM(database, field, criteria)  Returns the sum of values selected from a database tablelike array or range using a SQLlike query. Learn more 
Database  DVAR  DVAR(database, field, criteria)  Returns the variance of a population sample selected from a database tablelike array or range using a SQLlike query. Learn more 
Database  DVARP  DVARP(database, field, criteria)  Returns the variance of an entire population selected from a database tablelike array or range using a SQLlike query. Learn more 
Parser  TO_DATE  TO_DATE(value)  Converts a provided number to a date. Learn more 
Parser  TO_DOLLARS  TO_DOLLARS(value)  Converts a provided number to a dollar value. Learn more 
Parser  TO_PERCENT  TO_PERCENT(value)  Converts a provided number to a percentage. Learn more 
Parser  TO_PURE_NUMBER  TO_PURE_NUMBER(value)  Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting. Learn more 
Parser  TO_TEXT  TO_TEXT(value)  Converts a provided numeric value to a text value. Learn more 
Array  ARRAY_CONSTRAIN  ARRAY_CONSTRAIN(input_range, num_rows, num_cols)  Constrains an array result to a specified size. Only available in the new Google Sheets. Learn more 
Array  ARRAY_LITERAL  ARRAY_LITERAL(input_arrays, ...)  Returns an array with M rows and N columns from M 1xN arrays. Only available in the new Google Sheets. Learn more 
Array  ARRAY_ROW  ARRAY_ROW(elements, ...)  Returns an array made up of the elements passed in as arguments. Only available in the new Google Sheets. Learn more 
Array  EXPAND  EXPAND(array_formula)  Forces the automatic expansion of array formula output as the output size grows. Learn more 
Array  FREQUENCY  FREQUENCY(data, classes)  Calculates the frequency distribution of a onecolumn array into specified classes. Learn more 
Array  GROWTH  GROWTH(known_data_y, known_data_x, new_data_x, b)  Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values. Learn more 
Array  LINEST  LINEST(known_data_y, known_data_x, b, verbose)  Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the leastsquares method. Learn more 
Array  LOGEST  LOGEST(known_data_y, known_data_x, b, verbose)  Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve. Learn more 
Array  MDETERM  MDETERM(square_matrix)  Returns the matrix determinant of a square matrix specified as an array or range. Learn more 
Array  MINVERSE  MINVERSE(square_matrix)  Returns the multiplicative inverse of a square matrix specified as an array or range. Learn more 
Array  MMULT  MMULT(matrix1, matrix2)  Calculates the matrix product of two matrices specified as arrays or ranges. Learn more 
Array  NOEXPAND  NOEXPAND(array_formula)  Prevents the automatic expansion of array formula output as the output size grows. Learn more 
Array  SUMPRODUCT  SUMPRODUCT(array1, array2)  Calculates the sum of the products of corresponding entries in two equalsized arrays or ranges. Learn more 
Array  SUMX2MY2  SUMX2MY2(array_x, array_y)  Calculates the sum of the differences of the squares of values in two arrays. Learn more 
Array  SUMX2PY2  SUMX2PY2(array_x, array_y)  Calculates the sum of the sums of the squares of values in two arrays. Learn more 
Array  SUMXMY2  SUMXMY2(array_x, array_y)  Calculates the sum of the squares of differences of values in two arrays. Learn more 
Array  TRANSPOSE  TRANSPOSE(array_or_range)  Transposes the rows and columns of an array or range of cells. Learn more 
Array  TREND  TREND(known_data_y, known_data_x, new_data_x, b)  Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values. Learn more 