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.

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.

Leave a Comment