Google Sheets Function List to Master | Most Commonly Used Formulas in Google Sheets

With growing demand among businesses for understanding the data, Google Sheets has gained huge popularity over time. If you are using Google Sheets for basic calculations then you aren’t using it to the fullest. Become a master in Google Sheets by using the Google Sheets Function List to format heavy data. Read on to know how many of the formulas you actually know by seeing our Google Sheet Formula List PDF.

Google Sheets Formulas and Functions List

Here we will list out the Google Sheets Functions Cheatsheet that you can explore and make the most out of the spreadsheet app like never before.

Filter Functions
Math Functions
Financial Functions
Google Functions
Info Functions
Logical Functions
Lookup Functions
Operator Functions
Statistical Functions
Text Functions
Database Functions
Array Functions
Web Functions
Date Functions
Engineering Functions

Google Sheets – Filter Functions

Name	Syntax	Description
FILTER Function	`FILTER(range, condition1, [condition2])`	Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.
SORT Function	`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.
SORTN Function	`SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)`	Returns the first n items in a data set after performing a sort.
UNIQUE Function	`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.

Google Sheets – Math Functions

Name	Syntax	Description
ABS Function	`ABS(value)`	Returns the absolute value of a number.
ACOS Function	`ACOS(value)`	Returns the inverse cosine of a value, in radians.
ACOSH Function	`ACOSH(value)`	Returns the inverse hyperbolic cosine of a number.
ACOT Function	`ACOT(value)`	Returns the inverse cotangent of a value, in radians.
ACOTH Function	`ACOTH(value)`	Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive.
ASIN Function	`ASIN(value)`	Returns the inverse sine of a value, in radians.
ASINH Function	`ASINH(value)`	Returns the inverse hyperbolic sine of a number.
ATAN Function	`ATAN(value)`	Returns the inverse tangent of a value, in radians.
ATAN2 Function	`ATAN2(x, y)`	Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (`x`,`y`), in radians.
ATANH Function	`ATANH(value)`	Returns the inverse hyperbolic tangent of a number.
BASE Function	`BASE(value, base, [min_length])`	Converts a number into a text representation in another base, for example, base 2 for binary.
CEILING Function	`CEILING(value, [factor])`	Rounds a number up to the nearest integer multiple of specified significance.
CEILING.MATH Function	`CEILING.MATH(number, [significance], [mode])`	Rounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode.
CEILING.PRECISE Function	`CEILING.PRECISE(number, [significance])`	Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up.
COMBIN Function	`COMBIN(n, k)`	Returns the number of ways to choose some number of objects from a pool of a given size of objects.
COMBINA Function	`COMBINA(n, k)`	Returns 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.
COS Function	`COS(angle)`	Returns the cosine of an angle provided in radians.
COSH Function	`COSH(value)`	Returns the hyperbolic cosine of any real number.
COT Function	`COT(angle)`	Cotangent of an angle provided in radians.
COTH Function	`COTH(value)`	Returns the hyperbolic cotangent of any real number.
COUNTBLANK Function	`COUNTBLANK(range)`	Returns the number of empty cells in a given range.
COUNTIF Function	`COUNTIF(range, criterion)`	Returns a conditional count across a range.
COUNTIFS Function	`COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])`	Returns the count of a range depending on multiple criteria.
COUNTUNIQUE Function	`COUNTUNIQUE(value1, [value2, ...])`	Counts the number of unique values in a list of specified values and ranges.
CSC Function	`CSC(angle)`	Returns the cosecant of an angle provided in radians.
CSCH Function	`CSCH(value)`	The CSCH function returns the hyperbolic cosecant of any real number.
DECIMAL Function	`DECIMAL(value, base)`	The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal).
DEGREES Function	`DEGREES(angle)`	Converts an angle value in radians to degrees.
ERFC Function	`ERFC(z)`	Returns the complementary Gauss error function of a value.
ERFC.PRECISE
EVEN Function	`EVEN(value)`	Rounds a number up to the nearest even integer.
EXP Function	`EXP(exponent)`	Returns Euler’s number, e (~2.718) raised to a power.
FACT Function	`FACT(value)`	Returns the factorial of a number.
FACTDOUBLE Function	`FACTDOUBLE(value)`	Returns the “double factorial” of a number.
FLOOR Function	`FLOOR(value, [factor])`	Rounds a number down to the nearest integer multiple of specified significance.
FLOOR.MATH Function	`FLOOR.MATH(number, [significance], [mode])`	Rounds a number down to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode.
FLOOR.PRECISE Function	`FLOOR.PRECISE(number, [significance])`	The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance.
GAMMALN Function	`GAMMALN(value)`	Returns the the logarithm of a specified Gamma function, base e (Euler’s number).
GAMMALN.PRECISE Function	`GAMMALN.PRECISE(value)`
GCD Function	`GCD(value1, value2)`	Returns the greatest common divisor of one or more integers.
IMLN Function	`IMLN(complex_value)`	Returns the logarithm of a complex number, base e (Euler’s number).
IMPOWER Function	`IMPOWER(complex_base, exponent)`	Returns a complex number raised to a power.
IMSQRT Function	`IMSQRT(complex_number)`	Computes the square root of a complex number.
INT Function	`INT(value)`	Rounds a number down to the nearest integer that is less than or equal to it.
ISEVEN Function	`ISEVEN(value)`	Checks whether the provided value is even.
ISO.CEILING Function	`ISO.CEILING(number, [significance])`
ISODD Function	`ISODD(value)`	Checks whether the provided value is odd.
LCM Function	`LCM(value1, value2)`	Returns the least common multiple of one or more integers.
LN Function	`LN(value)`	Returns the the logarithm of a number, base e (Euler’s number).
LOG Function	`LOG(value, base)`	Returns the the logarithm of a number given a base.
LOG10 Function	`LOG10(value)`	Returns the the logarithm of a number, base 10.
MOD Function	`MOD(dividend, divisor)`	Returns the result of the modulo operator, the remainder after a division operation.
MROUND Function	`MROUND(value, factor)`	Rounds one number to the nearest integer multiple of another.
MULTINOMIAL Function	`MULTINOMIAL(value1, value2)`	Returns the factorial of the sum of values divided by the product of the values’ factorials.
MUNIT Function	`MUNIT(dimension)`	Returns a unit matrix of size dimension x dimension.
ODD Function	`ODD(value)`	Rounds a number up to the nearest odd integer.
PI Function	`PI()`	Returns the value of Pi to 14 decimal places.
POWER Function	`POWER(base, exponent)`	Returns a number raised to a power.
PRODUCT Function	`PRODUCT(factor1, [factor2, ...])`	Returns the result of multiplying a series of numbers together.
QUOTIENT Function	`QUOTIENT(dividend, divisor)`	Returns one number divided by another.
RADIANS Function	`RADIANS(angle)`	Converts an angle value in degrees to radians.
RAND Function	`RAND()`	Returns a random number between 0 inclusive and 1 exclusive.
RANDARRAY Function	`RANDARRAY(rows, columns)`	Generates an array of random numbers between 0 and 1.
RANDBETWEEN Function	`RANDBETWEEN(low, high)`	Returns a uniformly random integer between two values, inclusive.
ROUND Function	`ROUND(value, [places])`	Rounds a number to a certain number of decimal places according to standard rules.
ROUNDDOWN Function	`ROUNDDOWN(value, [places])`	Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.
ROUNDUP Function	`ROUNDUP(value, [places])`	Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.
SEC Function	`SEC(angle)`	The SEC function returns the secant of an angle, measured in radians.
SECH Function	`SECH(value)`	The SECH function returns the hyperbolic secant of an angle.
SEQUENCE Function	`SEQUENCE(rows, columns, start, step)`	Returns an array of sequential numbers, such as 1, 2, 3, 4.
SERIESSUM Function	`SERIESSUM(x, n, m, a)`	Given 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`.
SIGN Function	`SIGN(value)`	Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.
SIN Function	`SIN(angle)`	Returns the sine of an angle provided in radians.
SINH Function	`SINH(value)`	Returns the hyperbolic sine of any real number.
SQRT Function	`SQRT(value)`	Returns the positive square root of a positive number.
SQRTPI Function	`SQRTPI(value)`	Returns the positive square root of the product of Pi and the given positive number.
SUBTOTAL Function	`SUBTOTAL(function_code, range1, [range2, ...])`	Returns a subtotal for a vertical range of cells using a specified aggregation function.
SUM Function	`SUM(value1, [value2, ...])`	Returns the sum of a series of numbers and/or cells.
SUMIF Function	`SUMIF(range, criterion, [sum_range])`	Returns a conditional sum across a range.
SUMIFS Function	`SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])`	Returns the sum of a range depending on multiple criteria.
SUMSQ Function	`SUMSQ(value1, [value2, ...])`	Returns the sum of the squares of a series of numbers and/or cells.
TAN Function	`TAN(angle)`	Returns the tangent of an angle provided in radians.
TANH Function	`TANH(value)`	Returns the hyperbolic tangent of any real number.
TRUNC Function	`TRUNC(value, [places])`	Truncates a number to a certain number of significant digits by omitting less significant digits.

Google Sheets Financial Functions

Name	Syntax	Description
ACCRINT Function	`ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention])`	Calculates the accrued interest of a security that has periodic payments.
ACCRINTM Function	`ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])`	Calculates the accrued interest of a security that pays interest at maturity.
AMORLINC Function	`AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis])`	Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.
COUPDAYBS Function	`COUPDAYBS(settlement, maturity, frequency, [day_count_convention])`	Calculates the number of days from the first coupon, or interest payment, until settlement.
COUPDAYS Function	`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.
COUPDAYSNC Function	`COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])`	Calculates the number of days from the settlement date until the next coupon, or interest payment.
COUPNCD Function	`COUPNCD(settlement, maturity, frequency, [day_count_convention])`	Calculates next coupon, or interest payment, date after the settlement date.
COUPNUM Function	`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.
COUPPCD Function	`COUPPCD(settlement, maturity, frequency, [day_count_convention])`	Calculates last coupon, or interest payment, date before the settlement date.
CUMIPMT Function	`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 constant-amount periodic payments and a constant interest rate.
CUMPRINC Function	`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 constant-amount periodic payments and a constant interest rate.
DB Function	`DB(cost, salvage, life, period, [month])`	Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.
DDB Function	`DDB(cost, salvage, life, period, [factor])`	Calculates the depreciation of an asset for a specified period using the double-declining balance method.
DISC Function	`DISC(settlement, maturity, price, redemption, [day_count_convention])`	Calculates the discount rate of a security based on price.
DOLLARDE Function	`DOLLARDE(fractional_price, unit)`	Converts a price quotation given as a decimal fraction into a decimal value.
DOLLARFR Function	`DOLLARFR(decimal_price, unit)`	Converts a price quotation given as a decimal value into a decimal fraction.
DURATION Function	`DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])`	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.
EFFECT Function	`EFFECT(nominal_rate, periods_per_year)`	Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.
FV Function	`FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])`	Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.
FVSCHEDULE Function	`FVSCHEDULE(principal, rate_schedule)`	Calculates the future value of some principal based on a specified series of potentially varying interest rates.
INTRATE Function	`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.
IPMT Function	`IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])`	Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.
IRR Function	`IRR(cashflow_amounts, [rate_guess])`	Calculates the internal rate of return on an investment based on a series of periodic cash flows.
ISPMT Function	`ISPMT(rate, period, number_of_periods, present_value)`	The ISPMT function calculates the interest paid during a particular period of an investment.
MDURATION Function	`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.
MIRR Function	`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.
NOMINAL Function	`NOMINAL(effective_rate, periods_per_year)`	Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.
NPER Function	`NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])`	Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.
NPV Function	`NPV(discount, cashflow1, [cashflow2, ...])`	Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.
PDURATION Function	`PDURATION(rate, present_value, future_value)`	Returns the number of periods for an investment to reach a specific value at a given rate.
PMT Function	`PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])`	Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.
PPMT Function	`PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])`	Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.
PRICE Function	`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.
PRICEDISC Function	`PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])`	Calculates the price of a discount (non-interest-bearing) security, based on expected yield.
PRICEMAT Function	`PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])`	Calculates the price of a security paying interest at maturity, based on expected yield.
PV Function	`PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])`	Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.
RATE Function	`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 constant-amount periodic payments and the assumption of a constant interest rate.
RECEIVED Function	`RECEIVED(settlement, maturity, investment, discount, [day_count_convention])`	Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date.
RRI Function	`RRI(number_of_periods, present_value, future_value)`	Returns the interest rate needed for an investment to reach a specific value within a given number of periods.
SLN Function	`SLN(cost, salvage, life)`	Calculates the depreciation of an asset for one period using the straight-line method.
SYD Function	`SYD(cost, salvage, life, period)`	Calculates the depreciation of an asset for a specified period using the sum of years digits method.
TBILLEQ Function	`TBILLEQ(settlement, maturity, discount)`	Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.
TBILLPRICE Function	`TBILLPRICE(settlement, maturity, discount)`	Calculates the price of a US Treasury Bill based on discount rate.
TBILLYIELD Function	`TBILLYIELD(settlement, maturity, price)`	Calculates the yield of a US Treasury Bill based on price.
VDB Function	`VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])`	Returns the depreciation of an asset for a particular period (or partial period).
XIRR Function	`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.
XNPV Function	`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.
YIELD Function	`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.
YIELDDISC Function	`YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])`	Calculates the annual yield of a discount (non-interest-bearing) security, based on price.
YIELDMAT Function	`YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])`	Calculates the annual yield of a security paying interest at maturity, based on price.

Sheets Google Functions

Name	Syntax	Description
ARRAYFORMULA Function	`ARRAYFORMULA(array_formula)`	Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays.
DETECTLANGUAGE Function	`DETECTLANGUAGE(text_or_range)`	Identifies the language used in text within the specified range.
GOOGLEFINANCE Function	`GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date\|num_days], [interval])`	Fetches current or historical securities information from Google Finance.
GOOGLETRANSLATE Function	`GOOGLETRANSLATE(text, [source_language], [target_language])`	Translates text from one language into another
IMAGE Function	`IMAGE(url, [mode], [height], [width])`	Inserts an image into a cell.
QUERY Function	`QUERY(data, query, [headers])`	Runs a Google Visualization API Query Language query across data.
SPARKLINE Function	`SPARKLINE(data, [options])`	Creates a miniature chart contained within a single cell.

Google Sheets Info Functions

Name	Syntax	Description
ERROR.TYPE Function	`ERROR.TYPE(reference)`	Returns a number corresponding to the error value in a different cell.
ISBLANK Function	`ISBLANK(value)`	Checks whether the referenced cell is empty.
ISDATE Function	`ISDATE(value)`	Returns whether a value is a date.
ISEMAIL Function	`ISEMAIL(value)`	Checks whether a value is a valid email address.
ISERR Function	`ISERR(value)`	Checks whether a value is an error other than `#N/A`.
ISERROR Function	`ISERROR(value)`	Checks whether a value is an error.
ISFORMULA Function	`ISFORMULA(cell)`	Checks whether a formula is in the referenced cell.
ISLOGICAL Function	`ISLOGICAL(value)`	Checks whether a value is `TRUE` or `FALSE`.
ISNA Function	`ISNA(value)`	Checks whether a value is the error `#N/A`.
ISNONTEXT Function	`ISNONTEXT(value)`	Checks whether a value is non-textual.
ISNUMBER Function	`ISNUMBER(value)`	Checks whether a value is a number.
ISREF Function	`ISREF(value)`	Checks whether a value is a valid cell reference.
ISTEXT Function	`ISTEXT(value)`	Checks whether a value is text.
N Function	`N(value)`	Returns the argument provided as a number.
NA Function	`NA()`	Returns the “value not available” error, `#N/A`.
TYPE Function	`TYPE(value)`	Returns a number associated with the type of data passed into the function.
CELL Function	`CELL(info_type, reference)`	Returns the requested information about the specified cell.

Google Sheets Logical Functions

Type	Name	Syntax	Description
Logical	AND Function	`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.
Logical	FALSE Function	`FALSE()`	Returns the logical value `FALSE`.
Logical	IF Function	`IF(logical_expression, value_if_true, value_if_false)`	Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
Logical	IFERROR Function	`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.
Logical	IFNA Function	`IFNA(value, value_if_na)`	Evaluates a value. If the value is an #N/A error, returns the specified value.
Logical	IFS Function	`IFS(condition1, value1, [condition2, value2], …)`	Evaluates multiple conditions and returns a value that corresponds to the first true condition.
Logical	NOT Function	`NOT(logical_expression)`	Returns the opposite of a logical value – `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.
Logical	OR Function	`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.
Logical	SWITCH Function	`SWITCH(expression, case1, value1, [default or case2, value2], …)`	Tests 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.
Logical	TRUE Function	`TRUE()`	Returns the logical value `TRUE`.
Logical	XOR Function	`XOR(logical_expression1, [logical_expression2, ...])`	The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise.

Google Sheets Lookup Functions

Name	Syntax	Description
ADDRESS Function	`ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])`	Returns a cell reference as a string.
CHOOSE Function	`CHOOSE(index, choice1, [choice2, ...])`	Returns an element from a list of choices based on index.
COLUMN Function	`COLUMN([cell_reference])`	Returns the column number of a specified cell, with `A=1`.
COLUMNS Function	`COLUMNS(range)`	Returns the number of columns in a specified array or range.
FORMULATEXT Function	`FORMULATEXT(cell)`	Returns the formula as a string.
GETPIVOTDATA Function	`GETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]`	Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings.
HLOOKUP Function	`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.
INDEX Function	`INDEX(reference, [row], [column])`	Returns the content of a cell, specified by row and column offset.
INDIRECT Function	`INDIRECT(cell_reference_as_string, [is_A1_notation])`	Returns a cell reference specified by a string.
LOOKUP Function	`LOOKUP(search_key, search_range\|search_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.
MATCH Function	`MATCH(search_key, range, [search_type])`	Returns the relative position of an item in a range that matches a specified value.
OFFSET Function	`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.
ROW Function	`ROW([cell_reference])`	Returns the row number of a specified cell.
ROWS Function	`ROWS(range)`	Returns the number of rows in a specified array or range.
VLOOKUP Function	`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.

Google Sheets Operator Functions

Name	Syntax	Description
ADD Function	`ADD(value1, value2)`	Returns the sum of two numbers. Equivalent to the `+` operator.
CONCAT Function	`CONCAT(value1, value2)`	Returns the concatenation of two values. Equivalent to the `&` operator.
DIVIDE Function	`DIVIDE(dividend, divisor)`	Returns one number divided by another. Equivalent to the `/` operator.
EQ Function	`EQ(value1, value2)`	Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator.
GT Function	`GT(value1, value2)`	Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator.
GTE Function	`GTE(value1, value2)`	Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator.
ISBETWEEN Function	`ISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive)`	Checks whether a provided number is between two other numbers either inclusively or exclusively.
LT Function	`LT(value1, value2)`	Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator.
LTE Function	`LTE(value1, value2)`	Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator.
MINUS Function	`MINUS(value1, value2)`	Returns the difference of two numbers. Equivalent to the `-` operator.
MULTIPLY Function	`MULTIPLY(factor1, factor2)`	Returns the product of two numbers. Equivalent to the `*` operator.
NE Function	`NE(value1, value2)`	Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator.
POW Function	`POW(base, exponent)`	Returns a number raised to a power.
UMINUS Function	`UMINUS(value)`	Returns a number with the sign reversed.
UNARY_PERCENT Function	`UNARY_PERCENT(percentage)`	Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.
UNIQUE Function	`UNIQUE(range, by_column, exactly_once)`	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.
UPLUS Function	`UPLUS(value)`	Returns a specified number, unchanged.

Google Sheets Statistical Functions

Name	Syntax	Description
AVEDEV Function	`AVEDEV(value1, [value2, ...])`	Calculates the average of the magnitudes of deviations of data from a dataset’s mean. Learn more
AVERAGE Function	`AVERAGE(value1, [value2, ...])`	Returns the numerical average value in a dataset, ignoring text. Learn more
AVERAGE.WEIGHTED Function	`AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])`	Finds the weighted average of a set of values, given the values and the corresponding weights. Learn more.
AVERAGEA Function	`AVERAGEA(value1, [value2, ...])`	Returns the numerical average value in a dataset. Learn more
AVERAGEIF Function	`AVERAGEIF(criteria_range, criterion, [average_range])`	Returns the average of a range depending on criteria. Learn more
AVERAGEIFS Function	`AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])`	Returns the average of a range depending on multiple criteria. Learn more
BETA.DIST Function	`BETA.DIST(value, alpha, beta, cumulative, lower_bound, upper_bound)`	Returns the probability of a given value as defined by the beta distribution function. Learn more.
BETA.INV Function	`BETA.INV(probability, alpha, beta, lower_bound, upper_bound)`	Returns the value of the inverse beta distribution function for a given probability. Learn more.
BETADIST Function	`BETADIST(value, alpha, beta, lower_bound, upper_bound)`	See BETA.DIST.
BETAINV Function	`BETAINV(probability, alpha, beta, lower_bound, upper_bound)`	See BETA.INV
BINOM.DIST Function	`BINOM.DIST(num_successes, num_trials, prob_success, cumulative)`	See BINOMDIST
BINOM.INV Function	`BINOM.INV(num_trials, prob_success, target_prob)`	See CRITBINOM
BINOMDIST Function	`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
CHIDIST Function	`CHIDIST(x, degrees_freedom)`	Calculates the right-tailed chi-squared distribution, often used in hypothesis testing. Learn more
CHIINV Function	`CHIINV(probability, degrees_freedom)`	Calculates the inverse of the right-tailed chi-squared distribution. Learn more
CHISQ.DIST Function	`CHISQ.DIST(x, degrees_freedom, cumulative)`	Calculates the left-tailed chi-squared distribution, often used in hypothesis testing. Learn more
CHISQ.DIST.RT Function	`CHISQ.DIST.RT(x, degrees_freedom)`	Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing. Learn more
CHISQ.INV Function	`CHISQ.INV(probability, degrees_freedom)`	Calculates the inverse of the left-tailed chi-squared distribution. Learn more
CHISQ.INV.RT Function	`CHISQ.INV.RT(probability, degrees_freedom)`	Calculates the inverse of the right-tailed chi-squared distribution. Learn more
CHISQ.TEST Function	`CHISQ.TEST(observed_range, expected_range)`	See CHITEST
CHITEST Function	`CHITEST(observed_range, expected_range)`	Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution. Learn more
CONFIDENCE Function	`CONFIDENCE(alpha, standard_deviation, pop_size)`	See CONFIDENCE.NORM
CONFIDENCE.NORM Function	`CONFIDENCE.NORM(alpha, standard_deviation, pop_size)`	Calculates the width of half the confidence interval for a normal distribution. Learn more.
CONFIDENCE.T Function	`CONFIDENCE.T(alpha, standard_deviation, size)`	Calculates the width of half the confidence interval for a Student’s t-distribution. Learn more.
CORREL Function	`CORREL(data_y, data_x)`	Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more
COUNT Function	`COUNT(value1, [value2, ...])`	Returns a count of the number of numeric values in a dataset. Learn more
COUNTA Function	`COUNTA(value1, [value2, ...])`	Returns a count of the number of values in a dataset. Learn more
COVAR Function	`COVAR(data_y, data_x)`	Calculates the covariance of a dataset. Learn more
COVARIANCE.P Function	`COVARIANCE.P(data_y, data_x)`	See COVAR
COVARIANCE.S Function	`COVARIANCE.S(data_y, data_x)`	Calculates the covariance of a dataset, where the dataset is a sample of the total population. Learn more.
CRITBINOM Function	`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
DEVSQ Function	`DEVSQ(value1, value2)`	Calculates the sum of squares of deviations based on a sample. Learn more
EXPON.DIST Function	`EXPON.DIST(x, lambda, cumulative)`	Returns the value of the exponential distribution function with a specified lambda at a specified value. Learn more.
EXPONDIST Function	`EXPONDIST(x, lambda, cumulative)`	See EXPON.DIST
F.DIST Function	`F.DIST(x, degrees_freedom1, degrees_freedom2, cumulative)`	Calculates the left-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor’s F distribution. Learn more
F.DIST.RT Function	`F.DIST.RT(x, degrees_freedom1, degrees_freedom2)`	Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor’s F distribution. Learn more
F.INV Function	`F.INV(probability, degrees_freedom1, degrees_freedom2)`	Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution. Learn more
F.INV.RT Function	`F.INV.RT(probability, degrees_freedom1, degrees_freedom2)`	Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution. Learn more
F.TEST Function	`F.TEST(range1, range2)`	See FTEST.
FDIST Function	`FDIST(x, degrees_freedom1, degrees_freedom2)`	See F.DIST.RT.
FINV Function	`FINV(probability, degrees_freedom1, degrees_freedom2)`	See F.INV.RT
FISHER Function	`FISHER(value)`	Returns the Fisher transformation of a specified value. Learn more
FISHERINV Function	`FISHERINV(value)`	Returns the inverse Fisher transformation of a specified value. Learn more
FORECAST Function	`FORECAST(x, data_y, data_x)`	Calculates the expected y-value for a specified x based on a linear regression of a dataset. Learn more
FORECAST.LINEAR Function	`FORECAST.LINEAR(x, data_y, data_x)`	See FORECAST
FTEST Function	`FTEST(range1, range2)`	Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to have come from populations with the same variance. Learn more
GAMMA Function	`GAMMA(number)`	Returns the Gamma function evaluated at the specified value. Learn more.
GAMMA.DIST Function	`GAMMA.DIST(x, alpha, beta, cumulative)`	Calculates the gamma distribution, a two-parameter continuous probability distribution. Learn more
GAMMA.INV Function	`GAMMA.INV(probability, alpha, beta)`	The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function for the specified probability and alpha and beta parameters. Learn more.
GAMMADIST Function	`GAMMADIST(x, alpha, beta, cumulative)`	See GAMMA.DIST
GAMMAINV Function	`GAMMAINV(probability, alpha, beta)`	See GAMMA.INV.
GAUSS Function	`GAUSS(z)`	The GAUSS function returns the probability that a random variable, drawn from a normal distribution, will be between the mean and z standard deviations above (or below) the mean. Learn more.
GEOMEAN Function	`GEOMEAN(value1, value2)`	Calculates the geometric mean of a dataset. Learn more
HARMEAN Function	`HARMEAN(value1, value2)`	Calculates the harmonic mean of a dataset. Learn more
HYPGEOM.DIST Function	`HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)`	See HYPGEOMDIST
HYPGEOMDIST Function	`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
INTERCEPT Function	`INTERCEPT(data_y, data_x)`	Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0). Learn more
KURT Function	`KURT(value1, value2)`	Calculates the kurtosis of a dataset, which describes the shape, and in particular the “peakedness” of that dataset. Learn more
LARGE Function	`LARGE(data, n)`	Returns the nth largest element from a data set, where n is user-defined. Learn more
LOGINV Function	`LOGINV(x, mean, standard_deviation)`	Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value. Learn more
LOGNORM.DIST Function	`LOGNORM.DIST(x, mean, standard_deviation)`	See LOGNORMDIST
LOGNORM.INV Function	`LOGNORM.INV(x, mean, standard_deviation)`	See LOGINV
LOGNORMDIST Function	`LOGNORMDIST(x, mean, standard_deviation)`	Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value. Learn more
MAX Function	`MAX(value1, [value2, ...])`	Returns the maximum value in a numeric dataset. Learn more
MAXA Function	`MAXA(value1, value2)`	Returns the maximum numeric value in a dataset. Learn more
MAXIFS Function	`MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)`	Returns the maximum value in a range of cells, filtered by a set of criteria. Learn more.
MEDIAN Function	`MEDIAN(value1, [value2, ...])`	Returns the median value in a numeric dataset. Learn more
MIN Function	`MIN(value1, [value2, ...])`	Returns the minimum value in a numeric dataset. Learn more
MINA Function	`MINA(value1, value2)`	Returns the minimum numeric value in a dataset. Learn more
MINIFS Function	`MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)`	Returns the minimum value in a range of cells, filtered by a set of criteria. Learn more.
MODE Function	`MODE(value1, [value2, ...])`	Returns the most commonly occurring value in a dataset. Learn more
MODE.MULT Function	`MODE.MULT(value1, value2)`	Returns the most commonly occurring values in a dataset. Learn more.
MODE.SNGL Function	`MODE.SNGL(value1, [value2, ...])`	See MODE
NEGBINOM.DIST Function	`NEGBINOM.DIST(num_failures, num_successes, prob_success)`	See NEGBINOMDIST
NEGBINOMDIST Function	`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
NORM.DIST Function	`NORM.DIST(x, mean, standard_deviation, cumulative)`	See NORMDIST
NORM.INV Function	`NORM.INV(x, mean, standard_deviation)`	See NORMINV
NORM.S.DIST Function	`NORM.S.DIST(x)`	See NORMSDIST
NORM.S.INV Function	`NORM.S.INV(x)`	See NORMSINV
NORMDIST Function	`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
NORMINV Function	`NORMINV(x, mean, standard_deviation)`	Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation. Learn more
NORMSDIST Function	`NORMSDIST(x)`	Returns the value of the standard normal cumulative distribution function for a specified value. Learn more
NORMSINV Function	`NORMSINV(x)`	Returns the value of the inverse standard normal distribution function for a specified value. Learn more
PEARSON Function	`PEARSON(data_y, data_x)`	Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more
PERCENTILE Function	`PERCENTILE(data, percentile)`	Returns the value at a given percentile of a dataset. Learn more
PERCENTILE.EXC Function	`PERCENTILE.EXC(data, percentile)`	Returns the value at a given percentile of a dataset, exclusive of 0 and 1. Learn more.
PERCENTILE.INC Function	`PERCENTILE.INC(data, percentile)`	See PERCENTILE
PERCENTRANK Function	`PERCENTRANK(data, value, [significant_digits])`	Returns the percentage rank (percentile) of a specified value in a dataset. Learn more
PERCENTRANK.EXC Function	`PERCENTRANK.EXC(data, value, [significant_digits])`	Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset. Learn more
PERCENTRANK.INC Function	`PERCENTRANK.INC(data, value, [significant_digits])`	Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset. Learn more
PERMUTATIONA Function	`PERMUTATIONA(number, number_chosen)`	Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects. Learn more.
PERMUT Function	`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
PHI Function	`PHI(x)`	The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1. Learn more.
POISSON Function	`POISSON(x, mean, cumulative)`	See POISSON.DIST
POISSON.DIST Function	`POISSON.DIST(x, mean, [cumulative])`	Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean. Learn more.
PROB Function	`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
QUARTILE Function	`QUARTILE(data, quartile_number)`	Returns a value nearest to a specified quartile of a dataset. Learn more
QUARTILE.EXC Function	`QUARTILE.EXC(data, quartile_number)`	Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4. Learn more.
QUARTILE.INC Function	`QUARTILE.INC(data, quartile_number)`	See QUARTILE
RANK Function	`RANK(value, data, [is_ascending])`	Returns the rank of a specified value in a dataset. Learn more
RANK.AVG Function	`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. Learn more
RANK.EQ Function	`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. Learn more
RSQ Function	`RSQ(data_y, data_x)`	Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset. Learn more
SKEW Function	`SKEW(value1, value2)`	Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean. Learn more
SKEW.P Function	`SKEW.P(value1, value2)`	Calculates the skewness of a dataset that represents the entire population. Learn more.
SLOPE Function	`SLOPE(data_y, data_x)`	Calculates the slope of the line resulting from linear regression of a dataset. Learn more
SMALL Function	`SMALL(data, n)`	Returns the nth smallest element from a data set, where n is user-defined. Learn more
STANDARDIZE Function	`STANDARDIZE(value, mean, standard_deviation)`	Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution. Learn more
STDEV Function	`STDEV(value1, [value2, ...])`	Calculates the standard deviation based on a sample. Learn more
STDEV.P Function	`STDEV.P(value1, [value2, ...])`	See STDEVP
STDEV.S Function	`STDEV.S(value1, [value2, ...])`	See STDEV
STDEVA Function	`STDEVA(value1, value2)`	Calculates the standard deviation based on a sample, setting text to the value `0`. Learn more
STDEVP Function	`STDEVP(value1, value2)`	Calculates the standard deviation based on an entire population. Learn more
STDEVPA Function	`STDEVPA(value1, value2)`	Calculates the standard deviation based on an entire population, setting text to the value `0`. Learn more
STEYX Function	`STEYX(data_y, data_x)`	Calculates the standard error of the predicted y-value for each x in the regression of a dataset. Learn more
T.DIST Function	`T.DIST(x, degrees_freedom, cumulative)`	Returns the right tailed Student distribution for a value x. Learn more.
T.DIST.2T Function	`T.DIST.2T(x, degrees_freedom)`	Returns the two tailed Student distribution for a value x. Learn more.
T.DIST.RT Function	`T.DIST.RT(x, degrees_freedom)`	Returns the right tailed Student distribution for a value x. Learn more.
T.INV Function	`T.INV(probability, degrees_freedom)`	Calculates the negative inverse of the one-tailed TDIST function. Learn more
T.INV.2T Function	`T.INV.2T(probability, degrees_freedom)`	Calculates the inverse of the two-tailed TDIST function. Learn more
T.TEST Function	`T.TEST(range1, range2, tails, type)`	Returns the probability associated with Student’s t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean. Learn more.
TDIST Function	`TDIST(x, degrees_freedom, tails)`	Calculates the probability for Student’s t-distribution with a given input (x). Learn more
TINV Function	`TINV(probability, degrees_freedom)`	See T.INV.2T
TRIMMEAN Function	`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
TTEST Function	`TTEST(range1, range2, tails, type)`	See T.TEST.
VAR Function	`VAR(value1, [value2, ...])`	Calculates the variance based on a sample. Learn more
VAR.P Function	`VAR.P(value1, [value2, ...])`	See VARP
VAR.S Function	`VAR.S(value1, [value2, ...])`	See VAR
VARA Function	`VARA(value1, value2)`	Calculates an estimate of variance based on a sample, setting text to the value `0`. Learn more
VARP Function	`VARP(value1, value2)`	Calculates the variance based on an entire population. Learn more
VARPA Function	`VARPA(value1, value2,...)`	Calculates the variance based on an entire population, setting text to the value `0`. Learn more
WEIBULL Function	`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
WEIBULL.DIST Function	`WEIBULL.DIST(x, shape, scale, cumulative)`	See WEIBULL
Z.TEST Function	`Z.TEST(data, value, [standard_deviation])`	Returns the one-tailed P-value of a Z-test with standard distribution. Learn more.
ZTEST Function	`ZTEST(data, value, [standard_deviation])`	See Z.TEST.

Google Sheets Text Functions

Name	Syntax	Description
ARABIC Function	`ARABIC(roman_numeral)`	Computes the value of a Roman numeral.
ASC Function	`ASC(text)`	Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged.
CHAR Function	`CHAR(table_number)`	Convert a number into a character according to the current Unicode table.
CLEAN Function	`CLEAN(text)`	Returns the text with the non-printable ASCII characters removed.
CODE Function	`CODE(string)`	Returns the numeric Unicode map value of the first character in the string provided.
CONCATENATE Function	`CONCATENATE(string1, [string2, ...])`	Appends strings to one another.
DOLLAR Function	`DOLLAR(number, [number_of_places])`	Formats a number into the locale-specific currency format.
EXACT Function	`EXACT(string1, string2)`	Tests whether two strings are identical.
FIND Function	`FIND(search_for, text_to_search, [starting_at])`	Returns the position at which a string is first found within text.
FINDB Function	`FINDB(search_for, text_to_search, [starting_at])`	Returns the position at which a string is first found within text counting each double-character as 2.
FIXED Function	`FIXED(number, [number_of_places], [suppress_separator])`	Formats a number with a fixed number of decimal places.
JOIN Function	`JOIN(delimiter, value_or_array1, [value_or_array2, ...])`	Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.
LEFT Function	`LEFT(string, [number_of_characters])`	Returns a substring from the beginning of a specified string.
LEFTB Function	`LEFTB(string, num_of_bytes)`	Returns the left portion of a string up to a certain number of bytes.
LEN Function	`LEN(text)`	Returns the length of a string.
LENB Function	`LENB(string)`	Returns the length of a string in bytes.”
LOWER Function	`LOWER(text)`	Converts a specified string to lowercase.
MID Function	`MID(string, starting_at, extract_length)`	Returns a segment of a string.
MIDB Function	`MIDB(string)`	Returns a section of a string starting at a given character and up to a specified number of bytes.
PROPER Function	`PROPER(text_to_capitalize)`	Capitalizes each word in a specified string.
REGEXEXTRACT Function	`REGEXEXTRACT(text, regular_expression)`	Extracts matching substrings according to a regular expression.
REGEXMATCH Function	`REGEXMATCH(text, regular_expression)`	Whether a piece of text matches a regular expression.
REGEXREPLACE Function	`REGEXREPLACE(text, regular_expression, replacement)`	Replaces part of a text string with a different text string using regular expressions.
REPLACE Function	`REPLACE(text, position, length, new_text)`	Replaces part of a text string with a different text string.
REPLACEB Function	`REPLACEB(text, position, num_bytes, new_text)`	Replaces part of a text string, based on a number of bytes, with a different text string.
REPT Function	`REPT(text_to_repeat, number_of_repetitions)`	Returns specified text repeated a number of times.
RIGHT Function	`RIGHT(string, [number_of_characters])`	Returns a substring from the end of a specified string.
RIGHTB Function	`RIGHTB(string, num_of_bytes)`	Returns the right portion of a string up to a certain number of bytes.
ROMAN Function	`ROMAN(number, [rule_relaxation])`	Formats a number in Roman numerals.
SEARCH Function	`SEARCH(search_for, text_to_search, [starting_at])`	Returns the position at which a string is first found within text.
SEARCHB Function	`SEARCHB(search_for, text_to_search, [starting_at])`	Returns the position at which a string is first found within text counting each double-character as 2.
SPLIT Function	`SPLIT(text, delimiter, [split_by_each], [remove_empty_text])`	Divides text around a specified character or string, and puts each fragment into a separate cell in the row.
SUBSTITUTE Function	`SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])`	Replaces existing text with new text in a string.
T Function	`T(value)`	Returns string arguments as text.
TEXT Function	`TEXT(number, format)`	Converts a number into text according to a specified format.
TEXTJOIN Function	`TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)`	Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.
TRIM Function	`TRIM(text)`	Removes leading and trailing spaces in a specified string.
UNICHAR Function	`UNICHAR(number)`	Returns the Unicode character for a number.
UNICODE Function	`UNICODE(text)`	Returns the decimal Unicode value of the first character of the text.
UPPER Function	`UPPER(text)`	Converts a specified string to uppercase.
VALUE Function	`VALUE(text)`	Converts a string in any of the date, time or number formats that Google Sheets understands into a number.

Google Sheets Database Functions

Name	Syntax	Description
DAVERAGE Function	`DAVERAGE(database, field, criteria)`	Returns the average of a set of values selected from a database table-like array or range using a SQL-like query.
DCOUNT Function	`DCOUNT(database, field, criteria)`	Counts numeric values selected from a database table-like array or range using a SQL-like query.
DCOUNTA Function	`DCOUNTA(database, field, criteria)`	Counts values, including text, selected from a database table-like array or range using a SQL-like query.
DGET Function	`DGET(database, field, criteria)`	Returns a single value from a database table-like array or range using a SQL-like query.
DMAX Function	`DMAX(database, field, criteria)`	Returns the maximum value selected from a database table-like array or range using a SQL-like query.
DMIN Function	`DMIN(database, field, criteria)`	Returns the minimum value selected from a database table-like array or range using a SQL-like query.
DPRODUCT Function	`DPRODUCT(database, field, criteria)`	Returns the product of values selected from a database table-like array or range using a SQL-like query.
DSTDEV Function	`DSTDEV(database, field, criteria)`	Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.
DSTDEVP Function	`DSTDEVP(database, field, criteria)`	Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.
DSUM Function	`DSUM(database, field, criteria)`	Returns the sum of values selected from a database table-like array or range using a SQL-like query.
DVAR Function	`DVAR(database, field, criteria)`	Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query.
DVARP Function	`DVARP(database, field, criteria)`	Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query.

Google Sheets Array Functions

Name	Syntax	Description
ARRAY_CONSTRAIN Function	`ARRAY_CONSTRAIN(input_range, num_rows, num_cols)`	Constrains an array result to a specified size.
FLATTEN Function	`FLATTEN(range1,[range2,...])`	Flattens all the values from one or more ranges into a single column.
FREQUENCY Function	`FREQUENCY(data, classes)`	Calculates the frequency distribution of a one-column array into specified classes.
GROWTH Function	`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.
LINEST Function	`LINEST(known_data_y, [known_data_x], [calculate_b], [verbose])`	Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method.
LOGEST Function	`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.
MDETERM Function	`MDETERM(square_matrix)`	Returns the matrix determinant of a square matrix specified as an array or range.
MINVERSE Function	`MINVERSE(square_matrix)`	Returns the multiplicative inverse of a square matrix specified as an array or range.
MMULT Function	`MMULT(matrix1, matrix2)`	Calculates the matrix product of two matrices specified as arrays or ranges.
SUMPRODUCT Function	`SUMPRODUCT(array1, [array2, ...])`	Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.
SUMX2MY2 Function	`SUMX2MY2(array_x, array_y)`	Calculates the sum of the differences of the squares of values in two arrays.
SUMX2PY2 Function	`SUMX2PY2(array_x, array_y)`	Calculates the sum of the sums of the squares of values in two arrays.
SUMXMY2 Function	`SUMXMY2(array_x, array_y)`	Calculates the sum of the squares of differences of values in two arrays.
TRANSPOSE Function	`TRANSPOSE(array_or_range)`	Transposes the rows and columns of an array or range of cells.
TREND Function	`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.

Google Sheets Web Functions

Name	Syntax	Description
ENCODEURL Function	`ENCODEURL(text)`	Encodes a string of text for the purpose of using in a URL query.
HYPERLINK Function	`HYPERLINK(url, [link_label])`	Creates a hyperlink inside a cell.
IMPORTDATA Function	`IMPORTDATA(url)`	Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.
IMPORTFEED Function	`IMPORTFEED(url, [query], [headers], [num_items])`	Imports a RSS or ATOM feed.
IMPORTHTML Function	`IMPORTHTML(url, query, index)`	Imports data from a table or list within an HTML page.
IMPORTRANGE Function	`IMPORTRANGE(spreadsheet_url, range_string)`	Imports a range of cells from a specified spreadsheet.
IMPORTXML Function	`IMPORTXML(url, xpath_query)`	Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.
ISURL Function	`ISURL(value)`	Checks whether a value is a valid URL.

Google Sheets – Date Functions

Name	Syntax	Description
DATE Function	`DATE(year, month, day)`	Converts a provided year, month, and day into a date.
DATEDIF Function	`DATEDIF(start_date, end_date, unit)`	Calculates the number of days, months, or years between two dates.
DATEVALUE Function	`DATEVALUE(date_string)`	Converts a provided date string in a known format to a date value.
DAY Function	`DAY(date)`	Returns the day of the month that a specific date falls on, in numeric format.
DAYS Function	`DAYS(end_date, start_date)`	Returns the number of days between two dates.
DAYS360 Function	`DAYS360(start_date, end_date, [method])`	Returns the difference between two days based on the 360 day year used in some financial interest calculations.
EDATE Function	`EDATE(start_date, months)`	Returns a date a specified number of months before or after another date.
EOMONTH Function	`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.
HOUR Function	`HOUR(time)`	Returns the hour component of a specific time, in numeric format.
ISOWEEKNUM Function	`ISOWEEKNUM(date)`	Returns the number of the ISO week of the year where the provided date falls.
MINUTE Function	`MINUTE(time)`	Returns the minute component of a specific time, in numeric format.
MONTH Function	`MONTH(date)`	Returns the month of the year a specific date falls in, in numeric format.
NETWORKDAYS Function	`NETWORKDAYS(start_date, end_date, [holidays])`	Returns the number of net working days between two provided days.
NETWORKDAYS.INTL Function	`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.
NOW Function	`NOW()`	Returns the current date and time as a date value.
SECOND Function	`SECOND(time)`	Returns the second component of a specific time, in numeric format.
TIME Function	`TIME(hour, minute, second)`	Converts a provided hour, minute, and second into a time.
TIMEVALUE Function	`TIMEVALUE(time_string)`	Returns the fraction of a 24-hour day the time represents.
TODAY Function	`TODAY()`	Returns the current date as a date value.
WEEKDAY Function	`WEEKDAY(date, [type])`	Returns a number representing the day of the week of the date provided.
WEEKNUM Function	`WEEKNUM(date, [type])`	Returns a number representing the week of the year where the provided date falls.
WORKDAY Function	`WORKDAY(start_date, num_days, [holidays])`	Calculates the end date after a specified number of working days.
WORKDAY.INTL Function	`WORKDAY.INTL(start_date, num_days, [weekend], [holidays])`	Calculates the date after a specified number of workdays excluding specified weekend days and holidays.
YEAR Function	`YEAR(date)`	Returns the year specified by a given date.
YEARFRAC Function	`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.

Google Sheets Functions Engineering

Name	Syntax	Description
BIN2DEC Function	`BIN2DEC(signed_binary_number)`	Converts a signed binary number to decimal format.
BIN2HEX Function	`BIN2HEX(signed_binary_number, [significant_digits])`	Converts a signed binary number to signed hexadecimal format.
BIN2OCT Function	`BIN2OCT(signed_binary_number, [significant_digits])`	Converts a signed binary number to signed octal format.
BITAND Function	`BITAND(value1, value2)`	Bitwise boolean AND of two numbers.
BITLSHIFT Function	`BITLSHIFT(value, shift_amount)`	Shifts the bits of the input a certain number of places to the left.
BITOR Function	`BITOR(value1, value2)`	Bitwise boolean OR of 2 numbers.
BITRSHIFT Function	`BITRSHIFT(value, shift_amount)`	Shifts the bits of the input a certain number of places to the right.
BITXOR Function	`BITXOR(value1, value2)`	Bitwise XOR (exclusive OR) of 2 numbers.
COMPLEX Function	`COMPLEX(real_part, imaginary_part, [suffix])`	Creates a complex number given real and imaginary coefficients.
DEC2BIN Function	`DEC2BIN(decimal_number, [significant_digits])`	Converts a decimal number to signed binary format.
DEC2HEX Function	`DEC2HEX(decimal_number, [significant_digits])`	Converts a decimal number to signed hexadecimal format.
DEC2OCT Function	`DEC2OCT(decimal_number, [significant_digits])`	Converts a decimal number to signed octal format.
DELTA Function	`DELTA(number1, [number2])`	Compare two numeric values, returning 1 if they’re equal.
ERF Function	`ERF(lower_bound, [upper_bound])`	The ERF function returns the integral of the Gauss error function over an interval of values.
ERF.PRECISE Function	`ERF.PRECISE(lower_bound, [upper_bound])`
GESTEP Function	`GESTEP(value, [step])`	Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise. If no step value is provided then the default value of 0 will be used.
HEX2BIN Function	`HEX2BIN(signed_hexadecimal_number, [significant_digits])`	Converts a signed hexadecimal number to signed binary format.
HEX2DEC Function	`HEX2DEC(signed_hexadecimal_number)`	Converts a signed hexadecimal number to decimal format.
HEX2OCT Function	`HEX2OCT(signed_hexadecimal_number, significant_digits)`	Converts a signed hexadecimal number to signed octal format.
IMABS Function	`IMABS(number)`	Returns absolute value of a complex number.
IMAGINARY Function	`IMAGINARY(complex_number)`	Returns the imaginary coefficient of a complex number.
IMARGUMENT Function	`IMARGUMENT(number)`	The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians.
IMCONJUGATE Function	`IMCONJUGATE(number)`	Returns the complex conjugate of a number.
IMCOS Function	`IMCOS(number)`	The IMCOS function returns the cosine of the given complex number.
IMCOSH Function	`IMCOSH(number)`	Returns the hyperbolic cosine of the given complex number. For example, a given complex number “x+yi” returns “cosh(x+yi).”
IMCOT Function	`IMCOT(number)`	Returns the cotangent of the given complex number. For example, a given complex number “x+yi” returns “cot(x+yi).”
IMCOTH Function	`IMCOTH(number)`	Returns the hyperbolic cotangent of the given complex number. For example, a given complex number “x+yi” returns “coth(x+yi).”
IMCSC Function	`IMCSC(number)`	Returns the cosecant of the given complex number.
IMCSCH Function	`IMCSCH(number)`	Returns the hyperbolic cosecant of the given complex number. For example, a given complex number “x+yi” returns “csch(x+yi).”
IMDIV Function	`IMDIV(dividend, divisor)`	Returns one complex number divided by another.
IMEXP Function	`IMEXP(exponent)`	Returns Euler’s number, e (~2.718) raised to a complex power.
IMLOG Function	`IMLOG(value, base)`	Returns the logarithm of a complex number for a specified base.
IMLOG10 Function	`IMLOG10(value)`	Returns the logarithm of a complex number with base 10.
IMLOG2 Function	`IMLOG2(value)`	Returns the logarithm of a complex number with base 2.
IMPRODUCT Function	`IMPRODUCT(factor1, [factor2, ...])`	Returns the result of multiplying a series of complex numbers together.
IMREAL Function	`IMREAL(complex_number)`	Returns the real coefficient of a complex number.
IMSEC Function	`IMSEC(number)`	Returns the secant of the given complex number. For example, a given complex number “x+yi” returns “sec(x+yi).”
IMSECH Function	`IMSECH(number)`	Returns the hyperbolic secant of the given complex number. For example, a given complex number “x+yi” returns “sech(x+yi).”
IMSIN Function	`IMSIN (number)`	Returns the sine of the given complex number.
IMSINH Function	`IMSINH(number)`	Returns the hyperbolic sine of the given complex number. For example, a given complex number “x+yi” returns “sinh(x+yi).”
IMSUB Function	`IMSUB(first_number, second_number)`	Returns the difference between two complex numbers.
IMSUM Function	`IMSUM(value1, [value2, ...])`	Returns the sum of a series of complex numbers.
IMTAN Function	`IMTAN(number)`	Returns the tangent of the given complex number.
IMTANH Function	`IMTANH(number)`	Returns the hyperbolic tangent of the given complex number. For example, a given complex number “x+yi” returns “tanh(x+yi).”
OCT2BIN Function	`OCT2BIN(signed_octal_number, [significant_digits])`	Converts a signed octal number to signed binary format.
OCT2DEC Function	`OCT2DEC(signed_octal_number)`	Converts a signed octal number to decimal format.
OCT2HEX Function	`OCT2HEX(signed_octal_number, [significant_digits])`	Converts a signed octal number to signed hexadecimal format.

Final Words

We believe you use the above listed Google Sheets Function List for achieving a number of statistical and data manipulation. Make your life easy with these Simple and Most Important Google Spreadsheet Functions. You might be interested in our other articles on Google Sheets Keyboard Shortcuts as well.

Must Read:

ULTRACEMCO Pivot Point Calculator