Google Sheets Formulas cheat sheet

ARRAY_CONSTRAIN

ARRAY_CONSTRAIN(input_range, num_rows, num_cols)

Constrains an array result to a specified size.

BYCOL

BYCOL(array_or_range, LAMBDA)

Groups an array by columns by application of a LAMBDA function to each column.

BYROW

BYROW(array_or_range, LAMBDA)

Groups an array by rows by application of a LAMBDA function to each row.

CHOOSECOLS

CHOOSECOLS(array, col_num1, [col_num2]) 

Creates a new array from the selected columns in the existing range.

CHOOSEROWS

CHOOSEROWS(array, row_num1, [row_num2])

Creates a new array from the selected rows in the existing range.

FLATTEN

FLATTEN(range1,[range2,...])

Flattens all the values from one or more ranges into a single column.

FREQUENCY

FREQUENCY(data, classes)

Calculates the frequency distribution of a one-column array into specified classes.

GROWTH

GROWTH(known_data_y, [known_data_x], [new_data_x], [b])

Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values.

HSTACK

HSTACK(range1; [range2, …])

Appends ranges horizontally and in sequence to return a larger array.

LINEST

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

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.

MAKEARRAY

MAKEARRAY(rows, columns, LAMBDA)

Returns an array of specified dimensions with values calculated by application of a LAMBDA function.

MAP

MAP(array1, [array2, ...], LAMBDA)

Maps each value in the given arrays to a new value by application of a LAMBDA function to each value.

MDETERM

MDETERM(square_matrix)

Returns the matrix determinant of a square matrix specified as an array or range.

MINVERSE

MINVERSE(square_matrix)

Returns the multiplicative inverse of a square matrix specified as an array or range.

MMULT

MMULT(matrix1, matrix2)

Calculates the matrix product of two matrices specified as arrays or ranges.

REDUCE

REDUCE(initial_value, array_or_range, LAMBDA)

Reduces an array to an accumulated result by application of a LAMBDA function to each value.

SCAN

SCAN(initial_value, array_or_range, LAMBDA)

Scans an array and produces intermediate values by application of a LAMBDA function to each value. Returns an array of the intermediate values obtained at each step.

SUMPRODUCT

SUMPRODUCT(array1, [array2, ...])

Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.

SUMX2MY2

SUMX2MY2(array_x, array_y)

Calculates the sum of the differences of the squares of values in two arrays.

SUMX2PY2

SUMX2PY2(array_x, array_y)

Calculates the sum of the sums of the squares of values in two arrays.

SUMXMY2

SUMXMY2(array_x, array_y)

Calculates the sum of the squares of differences of values in two arrays.

TOCOL

TOCOL(array_or_range, [ignore], [scan_by_column])

Transforms an array or range of cells into a single column.

TOROW

TOROW(array_or_range, [ignore], [scan_by_column])

Transforms an array or range of cells into a single row.

TRANSPOSE

TRANSPOSE(array_or_range)

Transposes the rows and columns of an array or range of cells.

TREND

TREND(known_data_y, [known_data_x], [new_data_x], [b])

Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values.

VSTACK

VSTACK(range1; [range2, …])

Appends ranges vertically and in sequence to return a larger array.

WRAPCOLS

WRAPCOLS(range, wrap_count, [pad_with])

Wraps the provided row or column of cells by columns after a specified number of elements to form a new array.

WRAPROWS

WRAPROWS(range, wrap_count, [pad_with])

Wraps the provided row or column of cells by rows after a specified number of elements to form a new array.

Here's how the provided table part would be formatted in markdown:

DAVERAGE

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

DCOUNT(database, field, criteria)

Counts numeric values selected from a database table-like array or range using a SQL-like query.

DCOUNTA

DCOUNTA(database, field, criteria)

Counts values, including text, selected from a database table-like array or range using a SQL-like query.

DGET

DGET(database, field, criteria)

Returns a single value from a database table-like array or range using a SQL-like query.

DMAX

DMAX(database, field, criteria)

Returns the maximum value selected from a database table-like array or range using a SQL-like query.

DMIN

DMIN(database, field, criteria)

Returns the minimum value selected from a database table-like array or range using a SQL-like query.

DPRODUCT

DPRODUCT(database, field, criteria)

Returns the product of values selected from a database table-like array or range using a SQL-like query.

DSTDEV

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

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

DSUM(database, field, criteria)

Returns the sum of values selected from a database table-like array or range using a SQL-like query.

DVAR

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

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.

For this part of the table related to date functions, here's how it would be translated into markdown format:

DATE

DATE(year, month, day)

Converts a provided year, month, and day into a date.

DATEDIF

DATEDIF(start_date, end_date, unit)

Calculates the number of days, months, or years between two dates.

DATEVALUE

DATEVALUE(date_string)

Converts a provided date string in a known format to a date value.

DAY

DAY(date)

Returns the day of the month that a specific date falls on, in numeric format.

DAYS

DAYS(end_date, start_date)

Returns the number of days between two dates.

DAYS360

DAYS360(start_date, end_date, [method])

Returns the difference between two days based on the 360 day year used in some financial interest calculations.

EDATE

EDATE(start_date, months)

Returns a date a specified number of months before or after another date.

EOMONTH

EOMONTH(start_date, months)

Returns a date representing the last day of a month which falls a specified number of months before or after another date.

EPOCHTODATE

EPOCHTODATE(timestamp, [unit])

Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC.

HOUR

HOUR(time)

Returns the hour component of a specific time, in numeric format.

ISOWEEKNUM

ISOWEEKNUM(date)

Returns the number of the ISO week of the year where the provided date falls.

MINUTE

MINUTE(time)

Returns the minute component of a specific time, in numeric format.

MONTH

MONTH(date)

Returns the month of the year a specific date falls in, in numeric format.

NETWORKDAYS

NETWORKDAYS(start_date, end_date, [holidays])

Returns the number of net working days between two provided days.

NETWORKDAYS.INTL

NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

Returns the number of net working days between two provided days excluding specified weekend days and holidays.

NOW

NOW()

Returns the current date and time as a date value.

SECOND

SECOND(time)

Returns the second component of a specific time, in numeric format.

TIME

TIME(hour, minute, second)

Converts a provided hour, minute, and second into a time.

TIMEVALUE

TIMEVALUE(time_string)

Returns the fraction of a 24-hour day the time represents.

TODAY

TODAY()

Returns the current date as a date value.

WEEKDAY

WEEKDAY(date, [type])

Returns a number representing the day of the week of the date provided.

WEEKNUM

WEEKNUM(date, [type])

Returns a number representing the week of the year where the provided date falls.

WORKDAY

WORKDAY(start_date, num_days, [holidays])

Calculates the end date after a specified number of working days.

WORKDAY.INTL

WORKDAY.INTL(start_date, num_days, [weekend], [holidays])

Calculates the date after a specified number of workdays excluding specified weekend days and holidays.

YEAR

YEAR(date)

Returns the year specified by a given date.

YEARFRAC

YEARFRAC(start_date, end_date, [day_count_convention])

Returns the number of years, including fractional years, between two dates using a specified day count convention.

Here's how the provided table part related to engineering functions would be translated into markdown format:

BIN2DEC

BIN2DEC(signed_binary_number)

Converts a signed binary number to decimal format.

BIN2HEX

BIN2HEX(signed_binary_number, [significant_digits])

Converts a signed binary number to signed hexadecimal format.

BIN2OCT

BIN2OCT(signed_binary_number, [significant_digits])

Converts a signed binary number to signed octal format.

BITAND

BITAND(value1, value2)

Bitwise boolean AND of two numbers.

BITLSHIFT

BITLSHIFT(value, shift_amount)

Shifts the bits of the input a certain number of places to the left.

BITOR

BITOR(value1, value2)

Bitwise boolean OR of 2 numbers.

BITRSHIFT

BITRSHIFT(value, shift_amount)

Shifts the bits of the input a certain number of places to the right.

BITXOR

BITXOR(value1, value2)

Bitwise XOR (exclusive OR) of 2 numbers.

COMPLEX

COMPLEX(real_part, imaginary_part, [suffix])

Creates a complex number given real and imaginary coefficients.

DEC2BIN

DEC2BIN(decimal_number, [significant_digits])

Converts a decimal number to signed binary format.

DEC2HEX

DEC2HEX(decimal_number, [significant_digits])

Converts a decimal number to signed hexadecimal format.

DEC2OCT

DEC2OCT(decimal_number, [significant_digits])

Converts a decimal number to signed octal format.

DELTA

DELTA(number1, [number2])

Compare two numeric values, returning 1 if they're equal.

ERF

ERF(lower_bound, [upper_bound])

The ERF function returns the integral of the Gauss error function over an interval of values.

ERF.PRECISE

ERF.PRECISE(lower_bound, [upper_bound])

See ERF for more details.

GESTEP

GESTEP(value, [step])

Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise.

HEX2BIN

HEX2BIN(signed_hexadecimal_number, [significant_digits])

Converts a signed hexadecimal number to signed binary format.

HEX2DEC

HEX2DEC(signed_hexadecimal_number)

Converts a signed hexadecimal number to decimal format.

HEX2OCT

HEX2OCT(signed_hexadecimal_number, significant_digits)

Converts a signed hexadecimal number to signed octal format.

IMABS

IMABS(number)

Returns absolute value of a complex number.

IMAGINARY

IMAGINARY(complex_number)

Returns the imaginary coefficient of a complex number.

IMARGUMENT

IMARGUMENT(number)

Returns the angle of the given complex number in radians.

IMCONJUGATE

IMCONJUGATE(number)

Returns the complex conjugate of a number.

IMCOS

IMCOS(number)

Returns the cosine of the given complex number.

IMCOSH

IMCOSH(number)

Returns the hyperbolic cosine of the given complex number.

IMCOT

IMCOT(number)

Returns the cotangent of the given complex number.

IMCOTH

IMCOTH(number)

Returns the hyperbolic cotangent of the given complex number.

IMCSC

IMCSC(number)

Returns the cosecant of the given complex number.

IMCSCH

IMCSCH(number)

Returns the hyperbolic cosecant of the given complex number.

IMDIV

IMDIV(dividend, divisor)

Returns one complex number divided by another.

IMEXP

IMEXP(exponent)

Returns Euler's number, e, raised to a complex power.

IMLOG

IMLOG(value, base)

Returns the logarithm of a complex number for a specified base.

IMLOG10

IMLOG10(value)

Returns the logarithm of a complex number with base 10.

IMLOG2

IMLOG2(value)

Returns the logarithm of a complex number with base 2.

IMPRODUCT

IMPRODUCT(factor1, [factor2, ...])

Returns the result of multiplying a series of

complex numbers together.

IMREAL

IMREAL(complex_number)

Returns the real coefficient of a complex number.

IMSEC

IMSEC(number)

Returns the secant of the given complex number.

IMSECH

IMSECH(number)

Returns the hyperbolic secant of the given complex number.

IMSIN

IMSIN(number)

Returns the sine of the given complex number.

IMSINH

IMSINH(number)

Returns the hyperbolic sine of the given complex number.

IMSUB

IMSUB(first_number, second_number)

Returns the difference between two complex numbers.

IMSUM

IMSUM(value1, [value2, ...])

Returns the sum of a series of complex numbers.

IMTAN

IMTAN(number)

Returns the tangent of the given complex number.

IMTANH

IMTANH(number)

Returns the hyperbolic tangent of the given complex number.

OCT2BIN

OCT2BIN(signed_octal_number, [significant_digits])

Converts a signed octal number to signed binary format.

OCT2DEC

OCT2DEC(signed_octal_number)

Converts a signed octal number to decimal format.

OCT2HEX

OCT2HEX(signed_octal_number, [significant_digits])

Converts a signed octal number to signed hexadecimal format.

Here's the markdown format for the provided table section related to filter functions:

FILTER

FILTER(range, condition1, [condition2])

Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.

SORT

SORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2])

Sorts the rows of a given array or range by the values in one or more columns.

SORTN

SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)

Returns the first n items in a data set after performing a sort.

UNIQUE

UNIQUE(range)

Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range.

Here's the markdown format for the provided table section related to financial functions:

ACCRINT

ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention])

Calculates the accrued interest of a security that has periodic payments.

ACCRINTM

ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])

Calculates the accrued interest of a security that pays interest at maturity.

AMORLINC

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

COUPDAYBS(settlement, maturity, frequency, [day_count_convention])

Calculates the number of days from the first coupon, or interest payment, until settlement.

COUPDAYS

COUPDAYS(settlement, maturity, frequency, [day_count_convention])

Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.

COUPDAYSNC

COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])

Calculates the number of days from the settlement date until the next coupon, or interest payment.

COUPNCD

COUPNCD(settlement, maturity, frequency, [day_count_convention])

Calculates next coupon, or interest payment, date after the settlement date.

COUPNUM

COUPNUM(settlement, maturity, frequency, [day_count_convention])

Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment.

COUPPCD

COUPPCD(settlement, maturity, frequency, [day_count_convention])

Calculates last coupon, or interest payment, date before the settlement date.

CUMIPMT

CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)

Calculates the cumulative interest over a range of payment periods for an investment.

CUMPRINC

CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)

Calculates the cumulative principal paid over a range of payment periods for an investment.

DB

DB(cost, salvage, life, period, [month])

Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.

DDB

DDB(cost, salvage, life, period, [factor])

Calculates the depreciation of an asset for a specified period using the double-declining balance method.

DISC

DISC(settlement, maturity, price, redemption, [day_count_convention])

Calculates the discount rate of a security based on price.

DOLLARDE

DOLLARDE(fractional_price, unit)

Converts a price quotation given as a decimal fraction into a decimal value.

DOLLARFR

DOLLARFR(decimal_price, unit)

Converts a price quotation given as a decimal value into a decimal fraction.

DURATION

DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])

Calculates the number of compounding periods required for an investment to reach a target value.

EFFECT

EFFECT(nominal_rate, periods_per_year)

Calculates the annual effective interest rate.

FV

FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])

Calculates the future value of an annuity investment.

FVSCHEDULE

FVSCHEDULE(principal, rate_schedule)

Calculates the future value of some principal based on a specified series of interest rates.

INTRATE

INTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention])

Calculates the effective interest rate generated by an investment.

IPMT

IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])

Calculates the payment on interest for an investment.

IRR

IRR(cashflow_amounts, [rate_guess])

Calculates the internal rate of return on an investment.

ISPMT

ISPMT(rate, period, number_of_periods, present_value)

Calculates the interest paid during a particular period of an investment.

MDURATION

MDURATION(set

tlement, maturity, rate, yield, frequency, [day_count_convention])

Calculates the modified Macaulay duration of a security.

MIRR

MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)

Calculates the modified internal rate of return on an investment.

NOMINAL

NOMINAL(effective_rate, periods_per_year)

Calculates the annual nominal interest rate.

NPER

NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])

Calculates the number of payment periods for an investment.

NPV

NPV(discount, cashflow1, [cashflow2, ...])

Calculates the net present value of an investment.

PDURATION

PDURATION(rate, present_value, future_value)

Returns the number of periods for an investment to reach a specific value.

PMT

PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])

Calculates the periodic payment for an annuity investment.

PPMT

PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])

Calculates the payment on the principal of an investment.

PRICE

PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])

Calculates the price of a security paying periodic interest.

PRICEDISC

PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])

Calculates the price of a discount security based on expected yield.

PRICEMAT

PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])

Calculates the price of a security paying interest at maturity.

PV

PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])

Calculates the present value of an annuity investment.

RATE

RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])

Calculates the interest rate of an annuity investment.

RECEIVED

RECEIVED(settlement, maturity, investment, discount, [day_count_convention])

Calculates the amount received at maturity for a fixed-income security.

RRI

RRI(number_of_periods, present_value, future_value)

Returns the interest rate needed for an investment to reach a specific value.

SLN

SLN(cost, salvage, life)

Calculates the straight-line depreciation of an asset.

SYD

SYD(cost, salvage, life, period)

Calculates the sum of years digits depreciation of an asset.

TBILLEQ

TBILLEQ(settlement, maturity, discount)

Calculates the equivalent annualized rate of return of a US Treasury Bill.

TBILLPRICE

TBILLPRICE(settlement, maturity, discount)

Calculates the price of a US Treasury Bill based on discount rate.

TBILLYIELD

TBILLYIELD(settlement, maturity, price)

Calculates the yield of a US Treasury Bill based on price.

VDB

VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])

Returns the depreciation of an asset for a specified period.

XIRR

XIRR(cashflow_amounts, cashflow_dates, [rate_guess])

Calculates the internal rate of return for a series of cash flows occurring at irregular intervals.

XNPV

XNPV(discount, cashflow_amounts, cashflow_dates)

Calculates the net present value for a series of cash flows occurring at irregular intervals.

YIELD

YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])

Calculates the annual yield of a security paying periodic interest.

YIELDDISC

YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])

Calculates the annual yield of a discount security based on price.

YIELDMAT

YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])

Calculates the annual yield of a security paying interest at maturity.

Here's the markdown format for the provided table section related to Google functions:

ARRAYFORMULA

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

DETECTLANGUAGE(text_or_range)

Identifies the language used in text within the specified range.

GOOGLEFINANCE

GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

Fetches current or historical securities information from Google Finance.

GOOGLETRANSLATE

GOOGLETRANSLATE(text, [source_language], [target_language])

Translates text from one language into another.

IMAGE

IMAGE(url, [mode], [height], [width])

Inserts an image into a cell.

QUERY

QUERY(data, query, [headers])

Runs a Google Visualization API Query Language query across data.

SPARKLINE

SPARKLINE(data, [options])

Creates a miniature chart contained within a single cell.

Here's the markdown format for the provided table section related to Info functions:

ERROR.TYPE

ERROR.TYPE(reference)

Returns a number corresponding to the error value in a different cell.

ISBLANK

ISBLANK(value)

Checks whether the referenced cell is empty.

ISDATE

ISDATE(value)

Returns whether a value is a date.

ISEMAIL

ISEMAIL(value)

Checks whether a value is a valid email address.

ISERR

ISERR(value)

Checks whether a value is an error other than #N/A.

ISERROR

ISERROR(value)

Checks whether a value is an error.

ISFORMULA

ISFORMULA(cell)

Checks whether a formula is in the referenced cell.

ISLOGICAL

ISLOGICAL(value)

Checks whether a value is TRUE or FALSE.

ISNA

ISNA(value)

Checks whether a value is the error #N/A.

ISNONTEXT

ISNONTEXT(value)

Checks whether a value is non-textual.

ISNUMBER

ISNUMBER(value)

Checks whether a value is a number.

ISREF

ISREF(value)

Checks whether a value is a valid cell reference.

ISTEXT

ISTEXT(value)

Checks whether a value is text.

N

N(value)

Returns the argument provided as a number.

NA

NA()

Returns the "value not available" error, #N/A.

TYPE

TYPE(value)

Returns a number associated with the type of data passed into the function.

CELL

CELL(info_type, reference)

Returns the requested information about the specified cell.

Here's the markdown format for the provided table section related to Logical functions:

AND

AND(logical_expression1, [logical_expression2, ...])

Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.

FALSE

FALSE()

Returns the logical value FALSE.

IF

IF(logical_expression, value_if_true, value_if_false)

Returns one value if a logical expression is TRUE and another if it is FALSE.

IFERROR

IFERROR(value, [value_if_error])

Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.

IFNA

IFNA(value, value_if_na)

Evaluates a value. If the value is an #N/A error, returns the specified value.

IFS

IFS(condition1, value1, [condition2, value2], …)

Evaluates multiple conditions and returns a value that corresponds to the first true condition.

LAMBDA

LAMBDA(name, formula_expression)

Creates and returns a custom function with a set of names and a formula_expression that uses them.

LET

LET(name1, value_expression1, [name2, …], [value_expression2, …], formula_expression)

Assigns name with the value_expression results and returns the result of the formula_expression.

NOT

NOT(logical_expression)

Returns the opposite of a logical value - NOT(TRUE) returns FALSE; NOT(FALSE) returns TRUE.

OR

OR(logical_expression1, [logical_expression2, ...])

Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.

SWITCH

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.

TRUE

TRUE()

Returns the logical value TRUE.

XOR

XOR(logical_expression1, [logical_expression2, ...])

Performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise.

Here's the markdown format for the provided table section related to Lookup functions:

ADDRESS

ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])

Returns a cell reference as a string.

CHOOSE

CHOOSE(index, choice1, [choice2, ...])

Returns an element from a list of choices based on index.

COLUMN

COLUMN([cell_reference])

Returns the column number of a specified cell, with A=1.

COLUMNS

COLUMNS(range)

Returns the number of columns in a specified array or range.

FORMULATEXT

FORMULATEXT(cell)

Returns the formula as a string.

GETPIVOTDATA

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

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

INDEX(reference, [row], [column])

Returns the content of a cell, specified by row and column offset.

INDIRECT

INDIRECT(cell_reference_as_string, [is_A1_notation])

Returns a cell reference specified by a string.

LOOKUP

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

MATCH(search_key, range, [search_type])

Returns the relative position of an item in a range that matches a specified value.

OFFSET

OFFSET(cell_reference, offset_rows, offset_columns, [height], [width])

Returns a range reference shifted a specified number of rows and columns from a starting cell reference.

ROW

ROW([cell_reference])

Returns the row number of a specified cell.

ROWS

ROWS(range)

Returns the number of rows in a specified array or range.

VLOOKUP

VLOOKUP(search_key, range, index, [is_sorted])

Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.

XLOOKUP

XLOOKUP(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode])

Returns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match.

Here's the markdown format for the provided table section related to Math functions:

ABS

ABS(value)

Returns the absolute value of a number.

ACOS

ACOS(value)

Returns the inverse cosine of a value, in radians.

ACOSH

ACOSH(value)

Returns the inverse hyperbolic cosine of a number.

ACOT

ACOT(value)

Returns the inverse cotangent of a value, in radians.

ACOTH

ACOTH(value)

Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive.

ASIN

ASIN(value)

Returns the inverse sine of a value, in radians.

ASINH

ASINH(value)

Returns the inverse hyperbolic sine of a number.

ATAN

ATAN(value)

Returns the inverse tangent of a value, in radians.

ATAN2

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

ATANH(value)

Returns the inverse hyperbolic tangent of a number.

BASE

BASE(value, base, [min_length])

Converts a number into a text representation in another base, for example, base 2 for binary.

CEILING

CEILING(value, [factor])

Rounds a number up to the nearest integer multiple of specified significance.

CEILING.MATH

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

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

COMBIN(n, k)

Returns the number of ways to choose some number of objects from a pool of a given size of objects.

COMBINA

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

COS(angle)

Returns the cosine of an angle provided in radians.

COSH

COSH(value)

Returns the hyperbolic cosine of any real number.

COT

COT(angle)

Cotangent of an angle provided in radians.

COTH

COTH(value)

Returns the hyperbolic cotangent of any real number.

COUNTBLANK

COUNTBLANK(range)

Returns the number of empty cells in a given range.

COUNTIF

COUNTIF(range, criterion)

Returns a conditional count across a range.

COUNTIFS

COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Returns the count of a range depending on multiple criteria.

COUNTUNIQUE

COUNTUNIQUE(value1, [value2, ...])

Counts the number of unique values in a list of specified values and ranges.

CSC

CSC(angle)

Returns the cosecant of an angle provided in radians.

CSCH

CSCH(value)

The CSCH function returns the hyperbolic cosecant of any real number.

DECIMAL

DECIMAL(value, base)

The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal).

DEGREES

DEGREES(angle)

Converts an angle value in radians to degrees.

ERFC

ERFC(z)

Returns the complementary Gauss error function of a value.

ERFC.PRECISE

ERFC.PRECISE(z)

See ERFC.

EVEN

EVEN(value)

Rounds a number up to the nearest even integer.

EXP

EXP(exponent)

Returns Euler's number, e (~2.718) raised to a power.

FACT

FACT(value)

Returns the factorial of a number.

FACTDOUBLE

FACTDOUBLE(value)

Returns the "double factorial" of a number.

FLOOR

FLOOR(value, [factor])

Rounds a number down to the nearest integer multiple of specified significance.

FLOOR

.MATH

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

FLOOR.PRECISE(number, [significance])

The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance.

GAMMALN

GAMMALN(value)

Returns the the logarithm of a specified Gamma function, base e (Euler's number).

GAMMALN.PRECISE

GAMMALN.PRECISE(value)

See GAMMALN.

GCD

GCD(value1, value2)

Returns the greatest common divisor of one or more integers.

IMLN

IMLN(complex_value)

Returns the logarithm of a complex number, base e (Euler's number).

IMPOWER

IMPOWER(complex_base, exponent)

Returns a complex number raised to a power.

IMSQRT

IMSQRT(complex_number)

Computes the square root of a complex number.

INT

INT(value)

Rounds a number down to the nearest integer that is less than or equal to it.

ISEVEN

ISEVEN(value)

Checks whether the provided value is even.

ISO.CEILING

ISO.CEILING(number, [significance])

See CEILING.PRECISE.

ISODD

ISODD(value)

Checks whether the provided value is odd.

LCM

LCM(value1, value2)

Returns the least common multiple of one or more integers.

LN

LN(value)

Returns the the logarithm of a number, base e (Euler's number).

LOG

LOG(value, base)

Returns the the logarithm of a number given a base.

LOG10

LOG10(value)

Returns the the logarithm of a number, base 10.

MOD

MOD(dividend, divisor)

Returns the result of the modulo operator, the remainder after a division operation.

MROUND

MROUND(value, factor)

Rounds one number to the nearest integer multiple of another.

MULTINOMIAL

MULTINOMIAL(value1, value2)

Returns the factorial of the sum of values divided by the product of the values' factorials.

MUNIT

MUNIT(dimension)

Returns a unit matrix of size dimension x dimension.

ODD

ODD(value)

Rounds a number up to the nearest odd integer.

PI

PI()

Returns the value of Pi to 14 decimal places.

POWER

POWER(base, exponent)

Returns a number raised to a power.

PRODUCT

PRODUCT(factor1, [factor2, ...])

Returns the result of multiplying a series of numbers together.

QUOTIENT

QUOTIENT(dividend, divisor)

Returns one number divided by another.

RADIANS

RADIANS(angle)

Converts an angle value in degrees to radians.

RAND

RAND()

Returns a random number between 0 inclusive and 1 exclusive.

RANDARRAY

RANDARRAY(rows, columns)

Generates an array of random numbers between 0 and 1.

RANDBETWEEN

RANDBETWEEN(low, high)

Returns a uniformly random integer between two values, inclusive.

ROUND

ROUND(value, [places])

Rounds a number to a certain number of decimal places according to standard rules.

ROUNDDOWN

ROUNDDOWN(value, [places])

Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.

ROUNDUP

ROUNDUP(value, [places])

Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

SEC

SEC(angle)

The SEC function returns the secant of an angle, measured in radians.

SECH

SECH(value)

The SECH function returns the hyperbolic secant of an angle.

SEQUENCE

SEQUENCE(rows, columns, start, step)

Returns an array of sequential numbers, such as 1, 2, 3, 4.

SERIESSUM

SERIESSUM(x, n, m, a)

Given parameters x, `n

,m, anda, returns the power series suma1x^n + a2x^(n+m) + ... + aix^(n+(i-1)m), whereiis the number of entries in rangea`.

SIGN

SIGN(value)

Given an input number, returns -1 if it is negative, 1 if positive, and 0 if it is zero.

SIN

SIN(angle)

Returns the sine of an angle provided in radians.

SINH

SINH(value)

Returns the hyperbolic sine of any real number.

SQRT

SQRT(value)

Returns the positive square root of a positive number.

SQRTPI

SQRTPI(value)

Returns the positive square root of the product of Pi and the given positive number.

SUBTOTAL

SUBTOTAL(function_code, range1, [range2, ...])

Returns a subtotal for a vertical range of cells using a specified aggregation function.

SUM

SUM(value1, [value2, ...])

Returns the sum of a series of numbers and/or cells.

SUMIF

SUMIF(range, criterion, [sum_range])

Returns a conditional sum across a range.

SUMIFS

SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Returns the sum of a range depending on multiple criteria.

SUMSQ

SUMSQ(value1, [value2, ...])

Returns the sum of the squares of a series of numbers and/or cells.

TAN

TAN(angle)

Returns the tangent of an angle provided in radians.

TANH

TANH(value)

Returns the hyperbolic tangent of any real number.

TRUNC

TRUNC(value, [places])

Truncates a number to a certain number of significant digits by omitting less significant digits.

ADD

ADD(value1, value2)

Returns the sum of two numbers. Equivalent to the + operator.

CONCAT

CONCAT(value1, value2)

Returns the concatenation of two values. Equivalent to the & operator.

DIVIDE

DIVIDE(dividend, divisor)

Returns one number divided by another. Equivalent to the / operator.

EQ

EQ(value1, value2)

Returns TRUE if two specified values are equal and FALSE otherwise. Equivalent to the = operator.

GT

GT(value1, value2)

Returns TRUE if the first argument is strictly greater than the second, and FALSE otherwise. Equivalent to the > operator.

GTE

GTE(value1, value2)

Returns TRUE if the first argument is greater than or equal to the second, and FALSE otherwise. Equivalent to the >= operator.

ISBETWEEN

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

LT(value1, value2)

Returns TRUE if the first argument is strictly less than the second, and FALSE otherwise. Equivalent to the < operator.

LTE

LTE(value1, value2)

Returns TRUE if the first argument is less than or equal to the second, and FALSE otherwise. Equivalent to the <= operator.

MINUS

MINUS(value1, value2)

Returns the difference of two numbers. Equivalent to the - operator.

MULTIPLY

MULTIPLY(factor1, factor2)

Returns the product of two numbers. Equivalent to the * operator.

NE

NE(value1, value2)

Returns TRUE if two specified values are not equal and FALSE otherwise. Equivalent to the <> operator.

POW

POW(base, exponent)

Returns a number raised to a power.

UMINUS

UMINUS(value)

Returns a number with the sign reversed.

UNARY_PERCENT

UNARY_PERCENT(percentage)

Returns a value interpreted as a percentage; that is, UNARY_PERCENT(100) equals 1.

UNIQUE

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

UPLUS(value)

Returns a specified number, unchanged.

CONVERT

CONVERT(value, start_unit, end_unit)

Converts a numeric value to a different unit of measure.

TO_DATE

TO_DATE(value)

Converts a provided number to a date.

TO_DOLLARS

TO_DOLLARS(value)

Converts a provided number to a dollar value.

TO_PERCENT

TO_PERCENT(value)

Converts a provided number to a percentage.

TO_PURE_NUMBER

TO_PURE_NUMBER(value)

Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting.

TO_TEXT

TO_TEXT(value)

Converts a provided numeric value to a text value.

AVEDEV

AVEDEV(value1, [value2, ...])

Calculates the average of the magnitudes of deviations of data from a dataset's mean.

AVERAGE

AVERAGE(value1, [value2, ...])

Returns the numerical average value in a dataset, ignoring text.

AVERAGE.WEIGHTED

AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])

Finds the weighted average of a set of values, given the values and the corresponding weights.

AVERAGEA

AVERAGEA(value1, [value2, ...])

Returns the numerical average value in a dataset.

AVERAGEIF

AVERAGEIF(criteria_range, criterion, [average_range])

Returns the average of a range depending on criteria.

AVERAGEIFS

AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Returns the average of a range depending on multiple criteria.

BETA.DIST

BETA.DIST(value, alpha, beta, cumulative, lower_bound, upper_bound)

Returns the probability of a given value as defined by the beta distribution function.

BETA.INV

BETA.INV(probability, alpha, beta, lower_bound, upper_bound)

Returns the value of the inverse beta distribution function for a given probability.

BETADIST

BETADIST(value, alpha, beta, lower_bound, upper_bound)

See BETA.DIST.

BETAINV

BETAINV(probability, alpha, beta, lower_bound, upper_bound)

See BETA.INV.

BINOM.DIST

BINOM.DIST(num_successes, num_trials, prob_success, cumulative)

See BINOMDIST.

BINOM.INV

BINOM.INV(num_trials, prob_success, target_prob)

See CRITBINOM.

BINOMDIST

BINOMDIST(num_successes, num_trials, prob_success, cumulative)

Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.

CHIDIST

CHIDIST(x, degrees_freedom)

Calculates the right-tailed chi-squared distribution, often used in hypothesis testing.

CHIINV

CHIINV(probability, degrees_freedom)

Calculates the inverse of the right-tailed chi-squared distribution.

CHISQ.DIST

CHISQ.DIST(x, degrees_freedom, cumulative)

Calculates the left-tailed chi-squared distribution, often used in hypothesis testing.

CHISQ.DIST.RT

CHISQ.DIST.RT(x, degrees_freedom)

Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing.

CHISQ.INV

CHISQ.INV(probability, degrees_freedom)

Calculates the inverse of the left-tailed chi-squared distribution.

CHISQ.INV.RT

CHISQ.INV.RT(probability, degrees_freedom)

Calculates the inverse of the right-tailed chi-squared distribution.

CHISQ.TEST

CHISQ.TEST(observed_range, expected_range)

See CHITEST.

CHITEST

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.

CONFIDENCE

CONFIDENCE(alpha, standard_deviation, pop_size)

See CONFIDENCE.NORM.

CONFIDENCE.NORM

CONFIDENCE.NORM(alpha, standard_deviation, pop_size)

Calculates the width of half the confidence interval for a normal distribution.

CONFIDENCE.T

CONFIDENCE.T(alpha, standard_deviation, size)

Calculates the width of half the confidence interval for a Student’s t-distribution.

CORREL

CORREL(data_y, data_x)

Calculates r, the Pearson product-moment correlation coefficient of a dataset.

COUNT

COUNT(value1, [value2, ...])

Returns a count of the number of numeric values in a dataset.

COUNTA

COUNTA(value1, [value2, ...])

Returns a count of the number of values in a dataset.

COVAR

COVAR(data_y, data_x

)

Calculates the covariance of a dataset.

COVARIANCE.P

COVARIANCE.P(data_y, data_x)

See COVAR.

COVARIANCE.S

COVARIANCE.S(data_y, data_x)

Calculates the covariance of a dataset, where the dataset is a sample of the total population.

CRITBINOM

CRITBINOM(num_trials, prob_success, target_prob)

Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria.

DEVSQ

DEVSQ(value1, value2)

Calculates the sum of squares of deviations based on a sample.

EXPON.DIST

EXPON.DIST(x, LAMBDA, cumulative)

Returns the value of the exponential distribution function with a specified LAMBDA at a specified value.

EXPONDIST

EXPONDIST(x, LAMBDA, cumulative)

See EXPON.DIST.

F.DIST

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.

F.DIST.RT

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.

F.INV

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.

F.INV.RT

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.

F.TEST

F.TEST(range1, range2)

See FTEST.

FDIST

FDIST(x, degrees_freedom1, degrees_freedom2)

See F.DIST.RT.

FINV

FINV(probability, degrees_freedom1, degrees_freedom2)

See F.INV.RT.

FISHER

FISHER(value)

Returns the Fisher transformation of a specified value.

FISHERINV

FISHERINV(value)

Returns the inverse Fisher transformation of a specified value.

FORECAST

FORECAST(x, data_y, data_x)

Calculates the expected y-value for a specified x based on a linear regression of a dataset.

FORECAST.LINEAR

FORECAST.LINEAR(x, data_y, data_x)

See FORECAST.

FTEST

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.

GAMMA

GAMMA(number)

Returns the Gamma function evaluated at the specified value.

GAMMA.DIST

GAMMA.DIST(x, alpha, beta, cumulative)

Calculates the gamma distribution, a two-parameter continuous probability distribution.

GAMMA.INV

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.

GAMMADIST

GAMMADIST(x, alpha, beta, cumulative)

See GAMMA.DIST.

GAMMAINV

GAMMAINV(probability, alpha, beta)

See GAMMA.INV.

GAUSS

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.

GEOMEAN

GEOMEAN(value1, value2)

Calculates the geometric mean of a dataset.

HARMEAN

HARMEAN(value1, value2)

Calculates the harmonic mean of a dataset.

HYPGEOM.DIST

HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)

See HYPGEOMDIST.

HYPGEOMDIST

HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)

Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws.

INTERCEPT

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).

KURT

KURT(value1, value2)

Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset.

LARGE

LARGE(data, n)

Returns the nth largest element from a data set, where n is user-defined.

LOGINV

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.

LOGNORM.DIST

LOGNORM.DIST(x, mean, standard_deviation)

See LOGNORMDIST.

LOGNORM.INV

LOGNORM.INV(x, mean, standard_deviation)

See LOGINV.

LOGNORMDIST

LOGNORMDIST(x, mean, standard_deviation)

Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value.

MARGINOFERROR

MARGINOFERROR(range, confidence)

Calculates the amount of random sampling error given a range of values and a confidence level.

MAX

MAX(value1, [value2, ...])

Returns the maximum value in a numeric dataset.

MAXA

MAXA(value1, value2)

Returns the maximum numeric value in a dataset.

MAXIFS

MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)

Returns the maximum value in a range of cells, filtered by a set of criteria.

MEDIAN

MEDIAN(value1, [value2, ...])

Returns the median value in a numeric dataset.

MIN

MIN(value1, [value2, ...])

Returns the minimum value in a numeric dataset.

MINA

MINA(value1, value2)

Returns the minimum numeric value in a dataset.

MINIFS

MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)

Returns the minimum value in a range of cells, filtered by a set of criteria.

MODE

MODE(value1, [value2, ...])

Returns the most commonly occurring value in a dataset.

MODE.MULT

MODE.MULT(value1, value2)

Returns the most commonly occurring values in a dataset.

MODE.SNGL

MODE.SNGL(value1, [value2, ...])

See MODE.

NEGBINOM.DIST

NEGBINOM.DIST(num_failures, num_successes, prob_success)

See NEGBINOMDIST.

NEGBINOMDIST

NEGBINOMDIST(num_failures, num_successes, prob_success)

Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials.

NORM.DIST

NORM.DIST(x, mean, standard_deviation, cumulative)

See NORMDIST.

NORM.INV

NORM.INV(x, mean, standard_deviation)

See NORMINV.

NORM.S.DIST

NORM.S.DIST(x)

See NORMSDIST.

NORM.S.INV

NORM.S.INV(x)

See NORMSINV.

NORMDIST

NORMDIST(x, mean, standard_deviation, cumulative)

Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.

NORMINV

NORMINV(x, mean, standard_deviation)

Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.

NORMSDIST

NORMSDIST(x)

Returns the value of the standard normal cumulative distribution function for a specified value.

NORMSINV

NORMSINV(x)

Returns the value of the inverse standard normal distribution function for a specified value.

PEARSON

PEARSON(data_y, data_x)

Calculates r, the Pearson product-moment correlation coefficient of a

dataset.

PERCENTILE

PERCENTILE(data, percentile)

Returns the value at a given percentile of a dataset.

PERCENTILE.EXC

PERCENTILE.EXC(data, percentile)

Returns the value at a given percentile of a dataset, exclusive of 0 and 1.

PERCENTILE.INC

PERCENTILE.INC(data, percentile)

See PERCENTILE.

PERCENTRANK

PERCENTRANK(data, value, [significant_digits])

Returns the percentage rank (percentile) of a specified value in a dataset.

PERCENTRANK.EXC

PERCENTRANK.EXC(data, value, [significant_digits])

Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.

PERCENTRANK.INC

PERCENTRANK.INC(data, value, [significant_digits])

Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset.

PERMUTATIONA

PERMUTATIONA(number, number_chosen)

Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects.

PERMUT

PERMUT(n, k)

Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order.

PHI

PHI(x)

The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1.

POISSON

POISSON(x, mean, cumulative)

See POISSON.DIST.

POISSON.DIST

POISSON.DIST(x, mean, [cumulative])

Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean.

PROB

PROB(data, probabilities, low_limit, [high_limit])

Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits.

QUARTILE

QUARTILE(data, quartile_number)

Returns a value nearest to a specified quartile of a dataset.

QUARTILE.EXC

QUARTILE.EXC(data, quartile_number)

Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4.

QUARTILE.INC

QUARTILE.INC(data, quartile_number)

See QUARTILE.

RANK

RANK(value, data, [is_ascending])

Returns the rank of a specified value in a dataset.

RANK.AVG

RANK.AVG(value, data, [is_ascending])

Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned.

RANK.EQ

RANK.EQ(value, data, [is_ascending])

Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned.

RSQ

RSQ(data_y, data_x)

Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.

SKEW

SKEW(value1, value2)

Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.

SKEW.P

SKEW.P(value1, value2)

Calculates the skewness of a dataset that represents the entire population.

SLOPE

SLOPE(data_y, data_x)

Calculates the slope of the line resulting from linear regression of a dataset.

SMALL

SMALL(data, n)

Returns the nth smallest element from a data set, where n is user-defined.

STANDARDIZE

STANDARDIZE(value, mean, standard_deviation)

Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution.

STDEV

STDEV(value1, [value2, ...])

Calculates the standard deviation based on a sample.

STDEV.P

STDEV.P(value1, [value2, ...])

See STDEVP.

STDEV.S

STDEV.S(value1, [value2, ...])

See STDEV.

STDEVA

STDEVA(value1, value2)

Calculates the standard deviation based on a sample, setting text

to the value 0.

STDEVP

STDEVP(value1, value2)

Calculates the standard deviation based on an entire population.

STDEVPA

STDEVPA(value1, value2)

Calculates the standard deviation based on an entire population, setting text to the value 0.

STEYX

STEYX(data_y, data_x)

Calculates the standard error of the predicted y-value for each x in the regression of a dataset.

T.DIST

T.DIST(x, degrees_freedom, cumulative)

Returns the right tailed Student distribution for a value x.

T.DIST.2T

T.DIST.2T(x, degrees_freedom)

Returns the two tailed Student distribution for a value x.

T.DIST.RT

T.DIST.RT(x, degrees_freedom)

Returns the right tailed Student distribution for a value x.

T.INV

T.INV(probability, degrees_freedom)

Calculates the negative inverse of the one-tailed TDIST function.

T.INV.2T

T.INV.2T(probability, degrees_freedom)

Calculates the inverse of the two-tailed TDIST function.

T.TEST

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.

TDIST

TDIST(x, degrees_freedom, tails)

Calculates the probability for Student's t-distribution with a given input (x).

TINV

TINV(probability, degrees_freedom)

See T.INV.2T.

TRIMMEAN

TRIMMEAN(data, exclude_proportion)

Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset.

TTEST

TTEST(range1, range2, tails, type)

See T.TEST.

VAR

VAR(value1, [value2, ...])

Calculates the variance based on a sample.

VAR.P

VAR.P(value1, [value2, ...])

See VARP.

VAR.S

VAR.S(value1, [value2, ...])

See VAR.

VARA

VARA(value1, value2)

Calculates an estimate of variance based on a sample, setting text to the value 0.

VARP

VARP(value1, value2)

Calculates the variance based on an entire population.

VARPA

VARPA(value1, value2,...)

Calculates the variance based on an entire population, setting text to the value 0.

WEIBULL

WEIBULL(x, shape, scale, cumulative)

Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale.

WEIBULL.DIST

WEIBULL.DIST(x, shape, scale, cumulative)

See WEIBULL.

Z.TEST

Z.TEST(data, value, [standard_deviation])

Returns the one-tailed P-value of a Z-test with standard distribution.

ZTEST

ZTEST(data, value, [standard_deviation])

See Z.TEST.

ARABIC

ARABIC(roman_numeral)

Computes the value of a Roman numeral.

ASC

ASC(text)

Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged.

CHAR

CHAR(table_number)

Convert a number into a character according to the current Unicode table.

CLEAN

CLEAN(text)

Returns the text with the non-printable ASCII characters removed.

CODE

CODE(string)

Returns the numeric Unicode map value of the first character in the string provided.

CONCATENATE

CONCATENATE(string1, [string2, ...])

Appends strings to one another.

DOLLAR

DOLLAR(number, [number_of_places])

Formats a number into the locale-specific currency format.

EXACT

EXACT(string1, string2)

Tests whether two strings are identical.

FIND

FIND(search_for, text_to_search, [starting_at])

Returns the position at which a string is first found within text.

FINDB

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

FIXED(number, [number_of_places], [suppress_separator])

Formats a number with a fixed number of decimal places.

JOIN

JOIN(delimiter, value_or_array1, [value_or_array2, ...])

Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.

LEFT

LEFT(string, [number_of_characters])

Returns a substring from the beginning of a specified string.

LEFTB

LEFTB(string, num_of_bytes)

Returns the left portion of a string up to a certain number of bytes.

LEN

LEN(text)

Returns the length of a string.

LENB

LENB(string)

Returns the length of a string in bytes.

LOWER

LOWER(text)

Converts a specified string to lowercase.

MID

MID(string, starting_at, extract_length)

Returns a segment of a string.

MIDB

MIDB(string)

Returns a section of a string starting at a given character and up to a specified number of bytes.

PROPER

PROPER(text_to_capitalize)

Capitalizes each word in a specified string.

REGEXEXTRACT

REGEXEXTRACT(text, regular_expression)

Extracts matching substrings according to a regular expression.

REGEXMATCH

REGEXMATCH(text, regular_expression)

Determines whether a piece of text matches a regular expression.

REGEXREPLACE

REGEXREPLACE(text, regular_expression, replacement)

Replaces part of a text string with a different text string using regular expressions.

REPLACE

REPLACE(text, position, length, new_text)

Replaces part of a text string with a different text string.

REPLACEB

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

REPT(text_to_repeat, number_of_repetitions)

Returns specified text repeated a number of times.

RIGHT

RIGHT(string, [number_of_characters])

Returns a substring from the end of a specified string.

RIGHTB

RIGHTB(string, num_of_bytes)

Returns the right portion of a string up to a certain number of bytes.

ROMAN

ROMAN(number, [rule_relaxation])

Formats a number in Roman numerals.

SEARCH

SEARCH(search_for, text_to_search, [starting_at])

Returns the position at which a string is first found within text.

SEARCHB

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

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

SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])

Replaces existing text with new text in a string.

T

T(value)

Returns string arguments as text.

TEXT

TEXT(number, format)

Converts a number into text according

to a specified format.

TEXTJOIN

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.

TRIM

TRIM(text)

Removes leading and trailing spaces in a specified string.

UNICHAR

UNICHAR(number)

Returns the Unicode character for a number.

UNICODE

UNICODE(text)

Returns the decimal Unicode value of the first character of the text.

UPPER

UPPER(text)

Converts a specified string to uppercase.

VALUE

VALUE(text)

Converts a string in any of the date, time, or number formats that Google Sheets understands into a number.

ENCODEURL

ENCODEURL(text)

Encodes a string of text for the purpose of using in a URL query.

HYPERLINK

HYPERLINK(url, [link_label])

Creates a hyperlink inside a cell.

IMPORTDATA

IMPORTDATA(url)

Imports data at a given URL in .csv (comma-separated value) or .tsv (tab-separated value) format.

IMPORTFEED

IMPORTFEED(url, [query], [headers], [num_items])

Imports an RSS or ATOM feed.

IMPORTHTML

IMPORTHTML(url, query, index)

Imports data from a table or list within an HTML page.

IMPORTRANGE

IMPORTRANGE(spreadsheet_url, range_string)

Imports a range of cells from a specified spreadsheet.

IMPORTXML

IMPORTXML(url, xpath_query)

Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.

ISURL

ISURL(value)

Checks whether a value is a valid URL.This comprehensive cheat sheet encompasses a wide range of functions available in Google Sheets, categorized into Array, Database, Date, Engineering, Filter, Financial, Google, Info, Logical, Lookup, Math, Operator, Parser, Statistical, Text, and Web. It provides concise descriptions and syntax for each function, making it an invaluable resource for users looking to perform various operations from simple calculations to complex data manipulation and web-based imports. Whether you're formatting data, analyzing statistics, or importing information from external sources, this cheat sheet is designed to enhance productivity and streamline your spreadsheet tasks.

ARRAY_CONSTRAIN

ARRAY_CONSTRAIN(input_range, num_rows, num_cols)

Constrains an array result to a specified size.

BYCOL

BYCOL(array_or_range, LAMBDA)

Groups an array by columns by application of a LAMBDA function to each column.

BYROW

BYROW(array_or_range, LAMBDA)

Groups an array by rows by application of a LAMBDA function to each row.

CHOOSECOLS

CHOOSECOLS(array, col_num1, [col_num2]) 

Creates a new array from the selected columns in the existing range.

CHOOSEROWS

CHOOSEROWS(array, row_num1, [row_num2])

Creates a new array from the selected rows in the existing range.

FLATTEN

FLATTEN(range1,[range2,...])

Flattens all the values from one or more ranges into a single column.

FREQUENCY

FREQUENCY(data, classes)

Calculates the frequency distribution of a one-column array into specified classes.

GROWTH

GROWTH(known_data_y, [known_data_x], [new_data_x], [b])

Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values.

HSTACK

HSTACK(range1; [range2, …])

Appends ranges horizontally and in sequence to return a larger array.

LINEST

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

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.

MAKEARRAY

MAKEARRAY(rows, columns, LAMBDA)

Returns an array of specified dimensions with values calculated by application of a LAMBDA function.

MAP

MAP(array1, [array2, ...], LAMBDA)

Maps each value in the given arrays to a new value by application of a LAMBDA function to each value.

MDETERM

MDETERM(square_matrix)

Returns the matrix determinant of a square matrix specified as an array or range.

MINVERSE

MINVERSE(square_matrix)

Returns the multiplicative inverse of a square matrix specified as an array or range.

MMULT

MMULT(matrix1, matrix2)

Calculates the matrix product of two matrices specified as arrays or ranges.

REDUCE

REDUCE(initial_value, array_or_range, LAMBDA)

Reduces an array to an accumulated result by application of a LAMBDA function to each value.

SCAN

SCAN(initial_value, array_or_range, LAMBDA)

Scans an array and produces intermediate values by application of a LAMBDA function to each value. Returns an array of the intermediate values obtained at each step.

SUMPRODUCT

SUMPRODUCT(array1, [array2, ...])

Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.

SUMX2MY2

SUMX2MY2(array_x, array_y)

Calculates the sum of the differences of the squares of values in two arrays.

SUMX2PY2

SUMX2PY2(array_x, array_y)

Calculates the sum of the sums of the squares of values in two arrays.

SUMXMY2

SUMXMY2(array_x, array_y)

Calculates the sum of the squares of differences of values in two arrays.

TOCOL

TOCOL(array_or_range, [ignore], [scan_by_column])

Transforms an array or range of cells into a single column.

TOROW

TOROW(array_or_range, [ignore], [scan_by_column])

Transforms an array or range of cells into a single row.

TRANSPOSE

TRANSPOSE(array_or_range)

Transposes the rows and columns of an array or range of cells.

TREND

TREND(known_data_y, [known_data_x], [new_data_x], [b])

Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values.

VSTACK

VSTACK(range1; [range2, …])

Appends ranges vertically and in sequence to return a larger array.

WRAPCOLS

WRAPCOLS(range, wrap_count, [pad_with])

Wraps the provided row or column of cells by columns after a specified number of elements to form a new array.

WRAPROWS

WRAPROWS(range, wrap_count, [pad_with])

Wraps the provided row or column of cells by rows after a specified number of elements to form a new array.

Here's how the provided table part would be formatted in markdown:

DAVERAGE

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

DCOUNT(database, field, criteria)

Counts numeric values selected from a database table-like array or range using a SQL-like query.

DCOUNTA

DCOUNTA(database, field, criteria)

Counts values, including text, selected from a database table-like array or range using a SQL-like query.

DGET

DGET(database, field, criteria)

Returns a single value from a database table-like array or range using a SQL-like query.

DMAX

DMAX(database, field, criteria)

Returns the maximum value selected from a database table-like array or range using a SQL-like query.

DMIN

DMIN(database, field, criteria)

Returns the minimum value selected from a database table-like array or range using a SQL-like query.

DPRODUCT

DPRODUCT(database, field, criteria)

Returns the product of values selected from a database table-like array or range using a SQL-like query.

DSTDEV

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

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

DSUM(database, field, criteria)

Returns the sum of values selected from a database table-like array or range using a SQL-like query.

DVAR

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

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.

For this part of the table related to date functions, here's how it would be translated into markdown format:

DATE

DATE(year, month, day)

Converts a provided year, month, and day into a date.

DATEDIF

DATEDIF(start_date, end_date, unit)

Calculates the number of days, months, or years between two dates.

DATEVALUE

DATEVALUE(date_string)

Converts a provided date string in a known format to a date value.

DAY

DAY(date)

Returns the day of the month that a specific date falls on, in numeric format.

DAYS

DAYS(end_date, start_date)

Returns the number of days between two dates.

DAYS360

DAYS360(start_date, end_date, [method])

Returns the difference between two days based on the 360 day year used in some financial interest calculations.

EDATE

EDATE(start_date, months)

Returns a date a specified number of months before or after another date.

EOMONTH

EOMONTH(start_date, months)

Returns a date representing the last day of a month which falls a specified number of months before or after another date.

EPOCHTODATE

EPOCHTODATE(timestamp, [unit])

Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC.

HOUR

HOUR(time)

Returns the hour component of a specific time, in numeric format.

ISOWEEKNUM

ISOWEEKNUM(date)

Returns the number of the ISO week of the year where the provided date falls.

MINUTE

MINUTE(time)

Returns the minute component of a specific time, in numeric format.

MONTH

MONTH(date)

Returns the month of the year a specific date falls in, in numeric format.

NETWORKDAYS

NETWORKDAYS(start_date, end_date, [holidays])

Returns the number of net working days between two provided days.

NETWORKDAYS.INTL

NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

Returns the number of net working days between two provided days excluding specified weekend days and holidays.

NOW

NOW()

Returns the current date and time as a date value.

SECOND

SECOND(time)

Returns the second component of a specific time, in numeric format.

TIME

TIME(hour, minute, second)

Converts a provided hour, minute, and second into a time.

TIMEVALUE

TIMEVALUE(time_string)

Returns the fraction of a 24-hour day the time represents.

TODAY

TODAY()

Returns the current date as a date value.

WEEKDAY

WEEKDAY(date, [type])

Returns a number representing the day of the week of the date provided.

WEEKNUM

WEEKNUM(date, [type])

Returns a number representing the week of the year where the provided date falls.

WORKDAY

WORKDAY(start_date, num_days, [holidays])

Calculates the end date after a specified number of working days.

WORKDAY.INTL

WORKDAY.INTL(start_date, num_days, [weekend], [holidays])

Calculates the date after a specified number of workdays excluding specified weekend days and holidays.

YEAR

YEAR(date)

Returns the year specified by a given date.

YEARFRAC

YEARFRAC(start_date, end_date, [day_count_convention])

Returns the number of years, including fractional years, between two dates using a specified day count convention.

Here's how the provided table part related to engineering functions would be translated into markdown format:

BIN2DEC

BIN2DEC(signed_binary_number)

Converts a signed binary number to decimal format.

BIN2HEX

BIN2HEX(signed_binary_number, [significant_digits])

Converts a signed binary number to signed hexadecimal format.

BIN2OCT

BIN2OCT(signed_binary_number, [significant_digits])

Converts a signed binary number to signed octal format.

BITAND

BITAND(value1, value2)

Bitwise boolean AND of two numbers.

BITLSHIFT

BITLSHIFT(value, shift_amount)

Shifts the bits of the input a certain number of places to the left.

BITOR

BITOR(value1, value2)

Bitwise boolean OR of 2 numbers.

BITRSHIFT

BITRSHIFT(value, shift_amount)

Shifts the bits of the input a certain number of places to the right.

BITXOR

BITXOR(value1, value2)

Bitwise XOR (exclusive OR) of 2 numbers.

COMPLEX

COMPLEX(real_part, imaginary_part, [suffix])

Creates a complex number given real and imaginary coefficients.

DEC2BIN

DEC2BIN(decimal_number, [significant_digits])

Converts a decimal number to signed binary format.

DEC2HEX

DEC2HEX(decimal_number, [significant_digits])

Converts a decimal number to signed hexadecimal format.

DEC2OCT

DEC2OCT(decimal_number, [significant_digits])

Converts a decimal number to signed octal format.

DELTA

DELTA(number1, [number2])

Compare two numeric values, returning 1 if they're equal.

ERF

ERF(lower_bound, [upper_bound])

The ERF function returns the integral of the Gauss error function over an interval of values.

ERF.PRECISE

ERF.PRECISE(lower_bound, [upper_bound])

See ERF for more details.

GESTEP

GESTEP(value, [step])

Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise.

HEX2BIN

HEX2BIN(signed_hexadecimal_number, [significant_digits])

Converts a signed hexadecimal number to signed binary format.

HEX2DEC

HEX2DEC(signed_hexadecimal_number)

Converts a signed hexadecimal number to decimal format.

HEX2OCT

HEX2OCT(signed_hexadecimal_number, significant_digits)

Converts a signed hexadecimal number to signed octal format.

IMABS

IMABS(number)

Returns absolute value of a complex number.

IMAGINARY

IMAGINARY(complex_number)

Returns the imaginary coefficient of a complex number.

IMARGUMENT

IMARGUMENT(number)

Returns the angle of the given complex number in radians.

IMCONJUGATE

IMCONJUGATE(number)

Returns the complex conjugate of a number.

IMCOS

IMCOS(number)

Returns the cosine of the given complex number.

IMCOSH

IMCOSH(number)

Returns the hyperbolic cosine of the given complex number.

IMCOT

IMCOT(number)

Returns the cotangent of the given complex number.

IMCOTH

IMCOTH(number)

Returns the hyperbolic cotangent of the given complex number.

IMCSC

IMCSC(number)

Returns the cosecant of the given complex number.

IMCSCH

IMCSCH(number)

Returns the hyperbolic cosecant of the given complex number.

IMDIV

IMDIV(dividend, divisor)

Returns one complex number divided by another.

IMEXP

IMEXP(exponent)

Returns Euler's number, e, raised to a complex power.

IMLOG

IMLOG(value, base)

Returns the logarithm of a complex number for a specified base.

IMLOG10

IMLOG10(value)

Returns the logarithm of a complex number with base 10.

IMLOG2

IMLOG2(value)

Returns the logarithm of a complex number with base 2.

IMPRODUCT

IMPRODUCT(factor1, [factor2, ...])

Returns the result of multiplying a series of

complex numbers together.

IMREAL

IMREAL(complex_number)

Returns the real coefficient of a complex number.

IMSEC

IMSEC(number)

Returns the secant of the given complex number.

IMSECH

IMSECH(number)

Returns the hyperbolic secant of the given complex number.

IMSIN

IMSIN(number)

Returns the sine of the given complex number.

IMSINH

IMSINH(number)

Returns the hyperbolic sine of the given complex number.

IMSUB

IMSUB(first_number, second_number)

Returns the difference between two complex numbers.

IMSUM

IMSUM(value1, [value2, ...])

Returns the sum of a series of complex numbers.

IMTAN

IMTAN(number)

Returns the tangent of the given complex number.

IMTANH

IMTANH(number)

Returns the hyperbolic tangent of the given complex number.

OCT2BIN

OCT2BIN(signed_octal_number, [significant_digits])

Converts a signed octal number to signed binary format.

OCT2DEC

OCT2DEC(signed_octal_number)

Converts a signed octal number to decimal format.

OCT2HEX

OCT2HEX(signed_octal_number, [significant_digits])

Converts a signed octal number to signed hexadecimal format.

Here's the markdown format for the provided table section related to filter functions:

FILTER

FILTER(range, condition1, [condition2])

Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.

SORT

SORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2])

Sorts the rows of a given array or range by the values in one or more columns.

SORTN

SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)

Returns the first n items in a data set after performing a sort.

UNIQUE

UNIQUE(range)

Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range.

Here's the markdown format for the provided table section related to financial functions:

ACCRINT

ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention])

Calculates the accrued interest of a security that has periodic payments.

ACCRINTM

ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])

Calculates the accrued interest of a security that pays interest at maturity.

AMORLINC

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

COUPDAYBS(settlement, maturity, frequency, [day_count_convention])

Calculates the number of days from the first coupon, or interest payment, until settlement.

COUPDAYS

COUPDAYS(settlement, maturity, frequency, [day_count_convention])

Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.

COUPDAYSNC

COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])

Calculates the number of days from the settlement date until the next coupon, or interest payment.

COUPNCD

COUPNCD(settlement, maturity, frequency, [day_count_convention])

Calculates next coupon, or interest payment, date after the settlement date.

COUPNUM

COUPNUM(settlement, maturity, frequency, [day_count_convention])

Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment.

COUPPCD

COUPPCD(settlement, maturity, frequency, [day_count_convention])

Calculates last coupon, or interest payment, date before the settlement date.

CUMIPMT

CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)

Calculates the cumulative interest over a range of payment periods for an investment.

CUMPRINC

CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)

Calculates the cumulative principal paid over a range of payment periods for an investment.

DB

DB(cost, salvage, life, period, [month])

Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.

DDB

DDB(cost, salvage, life, period, [factor])

Calculates the depreciation of an asset for a specified period using the double-declining balance method.

DISC

DISC(settlement, maturity, price, redemption, [day_count_convention])

Calculates the discount rate of a security based on price.

DOLLARDE

DOLLARDE(fractional_price, unit)

Converts a price quotation given as a decimal fraction into a decimal value.

DOLLARFR

DOLLARFR(decimal_price, unit)

Converts a price quotation given as a decimal value into a decimal fraction.

DURATION

DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])

Calculates the number of compounding periods required for an investment to reach a target value.

EFFECT

EFFECT(nominal_rate, periods_per_year)

Calculates the annual effective interest rate.

FV

FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])

Calculates the future value of an annuity investment.

FVSCHEDULE

FVSCHEDULE(principal, rate_schedule)

Calculates the future value of some principal based on a specified series of interest rates.

INTRATE

INTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention])

Calculates the effective interest rate generated by an investment.

IPMT

IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])

Calculates the payment on interest for an investment.

IRR

IRR(cashflow_amounts, [rate_guess])

Calculates the internal rate of return on an investment.

ISPMT

ISPMT(rate, period, number_of_periods, present_value)

Calculates the interest paid during a particular period of an investment.

MDURATION

MDURATION(set

tlement, maturity, rate, yield, frequency, [day_count_convention])

Calculates the modified Macaulay duration of a security.

MIRR

MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)

Calculates the modified internal rate of return on an investment.

NOMINAL

NOMINAL(effective_rate, periods_per_year)

Calculates the annual nominal interest rate.

NPER

NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])

Calculates the number of payment periods for an investment.

NPV

NPV(discount, cashflow1, [cashflow2, ...])

Calculates the net present value of an investment.

PDURATION

PDURATION(rate, present_value, future_value)

Returns the number of periods for an investment to reach a specific value.

PMT

PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])

Calculates the periodic payment for an annuity investment.

PPMT

PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])

Calculates the payment on the principal of an investment.

PRICE

PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])

Calculates the price of a security paying periodic interest.

PRICEDISC

PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])

Calculates the price of a discount security based on expected yield.

PRICEMAT

PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])

Calculates the price of a security paying interest at maturity.

PV

PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])

Calculates the present value of an annuity investment.

RATE

RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])

Calculates the interest rate of an annuity investment.

RECEIVED

RECEIVED(settlement, maturity, investment, discount, [day_count_convention])

Calculates the amount received at maturity for a fixed-income security.

RRI

RRI(number_of_periods, present_value, future_value)

Returns the interest rate needed for an investment to reach a specific value.

SLN

SLN(cost, salvage, life)

Calculates the straight-line depreciation of an asset.

SYD

SYD(cost, salvage, life, period)

Calculates the sum of years digits depreciation of an asset.

TBILLEQ

TBILLEQ(settlement, maturity, discount)

Calculates the equivalent annualized rate of return of a US Treasury Bill.

TBILLPRICE

TBILLPRICE(settlement, maturity, discount)

Calculates the price of a US Treasury Bill based on discount rate.

TBILLYIELD

TBILLYIELD(settlement, maturity, price)

Calculates the yield of a US Treasury Bill based on price.

VDB

VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])

Returns the depreciation of an asset for a specified period.

XIRR

XIRR(cashflow_amounts, cashflow_dates, [rate_guess])

Calculates the internal rate of return for a series of cash flows occurring at irregular intervals.

XNPV

XNPV(discount, cashflow_amounts, cashflow_dates)

Calculates the net present value for a series of cash flows occurring at irregular intervals.

YIELD

YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])

Calculates the annual yield of a security paying periodic interest.

YIELDDISC

YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])

Calculates the annual yield of a discount security based on price.

YIELDMAT

YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])

Calculates the annual yield of a security paying interest at maturity.

Here's the markdown format for the provided table section related to Google functions:

ARRAYFORMULA

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

DETECTLANGUAGE(text_or_range)

Identifies the language used in text within the specified range.

GOOGLEFINANCE

GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

Fetches current or historical securities information from Google Finance.

GOOGLETRANSLATE

GOOGLETRANSLATE(text, [source_language], [target_language])

Translates text from one language into another.

IMAGE

IMAGE(url, [mode], [height], [width])

Inserts an image into a cell.

QUERY

QUERY(data, query, [headers])

Runs a Google Visualization API Query Language query across data.

SPARKLINE

SPARKLINE(data, [options])

Creates a miniature chart contained within a single cell.

Here's the markdown format for the provided table section related to Info functions:

ERROR.TYPE

ERROR.TYPE(reference)

Returns a number corresponding to the error value in a different cell.

ISBLANK

ISBLANK(value)

Checks whether the referenced cell is empty.

ISDATE

ISDATE(value)

Returns whether a value is a date.

ISEMAIL

ISEMAIL(value)

Checks whether a value is a valid email address.

ISERR

ISERR(value)

Checks whether a value is an error other than #N/A.

ISERROR

ISERROR(value)

Checks whether a value is an error.

ISFORMULA

ISFORMULA(cell)

Checks whether a formula is in the referenced cell.

ISLOGICAL

ISLOGICAL(value)

Checks whether a value is TRUE or FALSE.

ISNA

ISNA(value)

Checks whether a value is the error #N/A.

ISNONTEXT

ISNONTEXT(value)

Checks whether a value is non-textual.

ISNUMBER

ISNUMBER(value)

Checks whether a value is a number.

ISREF

ISREF(value)

Checks whether a value is a valid cell reference.

ISTEXT

ISTEXT(value)

Checks whether a value is text.

N

N(value)

Returns the argument provided as a number.

NA

NA()

Returns the "value not available" error, #N/A.

TYPE

TYPE(value)

Returns a number associated with the type of data passed into the function.

CELL

CELL(info_type, reference)

Returns the requested information about the specified cell.

Here's the markdown format for the provided table section related to Logical functions:

AND

AND(logical_expression1, [logical_expression2, ...])

Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.

FALSE

FALSE()

Returns the logical value FALSE.

IF

IF(logical_expression, value_if_true, value_if_false)

Returns one value if a logical expression is TRUE and another if it is FALSE.

IFERROR

IFERROR(value, [value_if_error])

Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.

IFNA

IFNA(value, value_if_na)

Evaluates a value. If the value is an #N/A error, returns the specified value.

IFS

IFS(condition1, value1, [condition2, value2], …)

Evaluates multiple conditions and returns a value that corresponds to the first true condition.

LAMBDA

LAMBDA(name, formula_expression)

Creates and returns a custom function with a set of names and a formula_expression that uses them.

LET

LET(name1, value_expression1, [name2, …], [value_expression2, …], formula_expression)

Assigns name with the value_expression results and returns the result of the formula_expression.

NOT

NOT(logical_expression)

Returns the opposite of a logical value - NOT(TRUE) returns FALSE; NOT(FALSE) returns TRUE.

OR

OR(logical_expression1, [logical_expression2, ...])

Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.

SWITCH

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.

TRUE

TRUE()

Returns the logical value TRUE.

XOR

XOR(logical_expression1, [logical_expression2, ...])

Performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise.

Here's the markdown format for the provided table section related to Lookup functions:

ADDRESS

ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])

Returns a cell reference as a string.

CHOOSE

CHOOSE(index, choice1, [choice2, ...])

Returns an element from a list of choices based on index.

COLUMN

COLUMN([cell_reference])

Returns the column number of a specified cell, with A=1.

COLUMNS

COLUMNS(range)

Returns the number of columns in a specified array or range.

FORMULATEXT

FORMULATEXT(cell)

Returns the formula as a string.

GETPIVOTDATA

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

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

INDEX(reference, [row], [column])

Returns the content of a cell, specified by row and column offset.

INDIRECT

INDIRECT(cell_reference_as_string, [is_A1_notation])

Returns a cell reference specified by a string.

LOOKUP

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

MATCH(search_key, range, [search_type])

Returns the relative position of an item in a range that matches a specified value.

OFFSET

OFFSET(cell_reference, offset_rows, offset_columns, [height], [width])

Returns a range reference shifted a specified number of rows and columns from a starting cell reference.

ROW

ROW([cell_reference])

Returns the row number of a specified cell.

ROWS

ROWS(range)

Returns the number of rows in a specified array or range.

VLOOKUP

VLOOKUP(search_key, range, index, [is_sorted])

Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.

XLOOKUP

XLOOKUP(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode])

Returns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match.

Here's the markdown format for the provided table section related to Math functions:

ABS

ABS(value)

Returns the absolute value of a number.

ACOS

ACOS(value)

Returns the inverse cosine of a value, in radians.

ACOSH

ACOSH(value)

Returns the inverse hyperbolic cosine of a number.

ACOT

ACOT(value)

Returns the inverse cotangent of a value, in radians.

ACOTH

ACOTH(value)

Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive.

ASIN

ASIN(value)

Returns the inverse sine of a value, in radians.

ASINH

ASINH(value)

Returns the inverse hyperbolic sine of a number.

ATAN

ATAN(value)

Returns the inverse tangent of a value, in radians.

ATAN2

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

ATANH(value)

Returns the inverse hyperbolic tangent of a number.

BASE

BASE(value, base, [min_length])

Converts a number into a text representation in another base, for example, base 2 for binary.

CEILING

CEILING(value, [factor])

Rounds a number up to the nearest integer multiple of specified significance.

CEILING.MATH

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

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

COMBIN(n, k)

Returns the number of ways to choose some number of objects from a pool of a given size of objects.

COMBINA

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

COS(angle)

Returns the cosine of an angle provided in radians.

COSH

COSH(value)

Returns the hyperbolic cosine of any real number.

COT

COT(angle)

Cotangent of an angle provided in radians.

COTH

COTH(value)

Returns the hyperbolic cotangent of any real number.

COUNTBLANK

COUNTBLANK(range)

Returns the number of empty cells in a given range.

COUNTIF

COUNTIF(range, criterion)

Returns a conditional count across a range.

COUNTIFS

COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Returns the count of a range depending on multiple criteria.

COUNTUNIQUE

COUNTUNIQUE(value1, [value2, ...])

Counts the number of unique values in a list of specified values and ranges.

CSC

CSC(angle)

Returns the cosecant of an angle provided in radians.

CSCH

CSCH(value)

The CSCH function returns the hyperbolic cosecant of any real number.

DECIMAL

DECIMAL(value, base)

The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal).

DEGREES

DEGREES(angle)

Converts an angle value in radians to degrees.

ERFC

ERFC(z)

Returns the complementary Gauss error function of a value.

ERFC.PRECISE

ERFC.PRECISE(z)

See ERFC.

EVEN

EVEN(value)

Rounds a number up to the nearest even integer.

EXP

EXP(exponent)

Returns Euler's number, e (~2.718) raised to a power.

FACT

FACT(value)

Returns the factorial of a number.

FACTDOUBLE

FACTDOUBLE(value)

Returns the "double factorial" of a number.

FLOOR

FLOOR(value, [factor])

Rounds a number down to the nearest integer multiple of specified significance.

FLOOR

.MATH

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

FLOOR.PRECISE(number, [significance])

The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance.

GAMMALN

GAMMALN(value)

Returns the the logarithm of a specified Gamma function, base e (Euler's number).

GAMMALN.PRECISE

GAMMALN.PRECISE(value)

See GAMMALN.

GCD

GCD(value1, value2)

Returns the greatest common divisor of one or more integers.

IMLN

IMLN(complex_value)

Returns the logarithm of a complex number, base e (Euler's number).

IMPOWER

IMPOWER(complex_base, exponent)

Returns a complex number raised to a power.

IMSQRT

IMSQRT(complex_number)

Computes the square root of a complex number.

INT

INT(value)

Rounds a number down to the nearest integer that is less than or equal to it.

ISEVEN

ISEVEN(value)

Checks whether the provided value is even.

ISO.CEILING

ISO.CEILING(number, [significance])

See CEILING.PRECISE.

ISODD

ISODD(value)

Checks whether the provided value is odd.

LCM

LCM(value1, value2)

Returns the least common multiple of one or more integers.

LN

LN(value)

Returns the the logarithm of a number, base e (Euler's number).

LOG

LOG(value, base)

Returns the the logarithm of a number given a base.

LOG10

LOG10(value)

Returns the the logarithm of a number, base 10.

MOD

MOD(dividend, divisor)

Returns the result of the modulo operator, the remainder after a division operation.

MROUND

MROUND(value, factor)

Rounds one number to the nearest integer multiple of another.

MULTINOMIAL

MULTINOMIAL(value1, value2)

Returns the factorial of the sum of values divided by the product of the values' factorials.

MUNIT

MUNIT(dimension)

Returns a unit matrix of size dimension x dimension.

ODD

ODD(value)

Rounds a number up to the nearest odd integer.

PI

PI()

Returns the value of Pi to 14 decimal places.

POWER

POWER(base, exponent)

Returns a number raised to a power.

PRODUCT

PRODUCT(factor1, [factor2, ...])

Returns the result of multiplying a series of numbers together.

QUOTIENT

QUOTIENT(dividend, divisor)

Returns one number divided by another.

RADIANS

RADIANS(angle)

Converts an angle value in degrees to radians.

RAND

RAND()

Returns a random number between 0 inclusive and 1 exclusive.

RANDARRAY

RANDARRAY(rows, columns)

Generates an array of random numbers between 0 and 1.

RANDBETWEEN

RANDBETWEEN(low, high)

Returns a uniformly random integer between two values, inclusive.

ROUND

ROUND(value, [places])

Rounds a number to a certain number of decimal places according to standard rules.

ROUNDDOWN

ROUNDDOWN(value, [places])

Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.

ROUNDUP

ROUNDUP(value, [places])

Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

SEC

SEC(angle)

The SEC function returns the secant of an angle, measured in radians.

SECH

SECH(value)

The SECH function returns the hyperbolic secant of an angle.

SEQUENCE

SEQUENCE(rows, columns, start, step)

Returns an array of sequential numbers, such as 1, 2, 3, 4.

SERIESSUM

SERIESSUM(x, n, m, a)

Given parameters x, `n

,m, anda, returns the power series suma1x^n + a2x^(n+m) + ... + aix^(n+(i-1)m), whereiis the number of entries in rangea`.

SIGN

SIGN(value)

Given an input number, returns -1 if it is negative, 1 if positive, and 0 if it is zero.

SIN

SIN(angle)

Returns the sine of an angle provided in radians.

SINH

SINH(value)

Returns the hyperbolic sine of any real number.

SQRT

SQRT(value)

Returns the positive square root of a positive number.

SQRTPI

SQRTPI(value)

Returns the positive square root of the product of Pi and the given positive number.

SUBTOTAL

SUBTOTAL(function_code, range1, [range2, ...])

Returns a subtotal for a vertical range of cells using a specified aggregation function.

SUM

SUM(value1, [value2, ...])

Returns the sum of a series of numbers and/or cells.

SUMIF

SUMIF(range, criterion, [sum_range])

Returns a conditional sum across a range.

SUMIFS

SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Returns the sum of a range depending on multiple criteria.

SUMSQ

SUMSQ(value1, [value2, ...])

Returns the sum of the squares of a series of numbers and/or cells.

TAN

TAN(angle)

Returns the tangent of an angle provided in radians.

TANH

TANH(value)

Returns the hyperbolic tangent of any real number.

TRUNC

TRUNC(value, [places])

Truncates a number to a certain number of significant digits by omitting less significant digits.

ADD

ADD(value1, value2)

Returns the sum of two numbers. Equivalent to the + operator.

CONCAT

CONCAT(value1, value2)

Returns the concatenation of two values. Equivalent to the & operator.

DIVIDE

DIVIDE(dividend, divisor)

Returns one number divided by another. Equivalent to the / operator.

EQ

EQ(value1, value2)

Returns TRUE if two specified values are equal and FALSE otherwise. Equivalent to the = operator.

GT

GT(value1, value2)

Returns TRUE if the first argument is strictly greater than the second, and FALSE otherwise. Equivalent to the > operator.

GTE

GTE(value1, value2)

Returns TRUE if the first argument is greater than or equal to the second, and FALSE otherwise. Equivalent to the >= operator.

ISBETWEEN

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

LT(value1, value2)

Returns TRUE if the first argument is strictly less than the second, and FALSE otherwise. Equivalent to the < operator.

LTE

LTE(value1, value2)

Returns TRUE if the first argument is less than or equal to the second, and FALSE otherwise. Equivalent to the <= operator.

MINUS

MINUS(value1, value2)

Returns the difference of two numbers. Equivalent to the - operator.

MULTIPLY

MULTIPLY(factor1, factor2)

Returns the product of two numbers. Equivalent to the * operator.

NE

NE(value1, value2)

Returns TRUE if two specified values are not equal and FALSE otherwise. Equivalent to the <> operator.

POW

POW(base, exponent)

Returns a number raised to a power.

UMINUS

UMINUS(value)

Returns a number with the sign reversed.

UNARY_PERCENT

UNARY_PERCENT(percentage)

Returns a value interpreted as a percentage; that is, UNARY_PERCENT(100) equals 1.

UNIQUE

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

UPLUS(value)

Returns a specified number, unchanged.

CONVERT

CONVERT(value, start_unit, end_unit)

Converts a numeric value to a different unit of measure.

TO_DATE

TO_DATE(value)

Converts a provided number to a date.

TO_DOLLARS

TO_DOLLARS(value)

Converts a provided number to a dollar value.

TO_PERCENT

TO_PERCENT(value)

Converts a provided number to a percentage.

TO_PURE_NUMBER

TO_PURE_NUMBER(value)

Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting.

TO_TEXT

TO_TEXT(value)

Converts a provided numeric value to a text value.

AVEDEV

AVEDEV(value1, [value2, ...])

Calculates the average of the magnitudes of deviations of data from a dataset's mean.

AVERAGE

AVERAGE(value1, [value2, ...])

Returns the numerical average value in a dataset, ignoring text.

AVERAGE.WEIGHTED

AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])

Finds the weighted average of a set of values, given the values and the corresponding weights.

AVERAGEA

AVERAGEA(value1, [value2, ...])

Returns the numerical average value in a dataset.

AVERAGEIF

AVERAGEIF(criteria_range, criterion, [average_range])

Returns the average of a range depending on criteria.

AVERAGEIFS

AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Returns the average of a range depending on multiple criteria.

BETA.DIST

BETA.DIST(value, alpha, beta, cumulative, lower_bound, upper_bound)

Returns the probability of a given value as defined by the beta distribution function.

BETA.INV

BETA.INV(probability, alpha, beta, lower_bound, upper_bound)

Returns the value of the inverse beta distribution function for a given probability.

BETADIST

BETADIST(value, alpha, beta, lower_bound, upper_bound)

See BETA.DIST.

BETAINV

BETAINV(probability, alpha, beta, lower_bound, upper_bound)

See BETA.INV.

BINOM.DIST

BINOM.DIST(num_successes, num_trials, prob_success, cumulative)

See BINOMDIST.

BINOM.INV

BINOM.INV(num_trials, prob_success, target_prob)

See CRITBINOM.

BINOMDIST

BINOMDIST(num_successes, num_trials, prob_success, cumulative)

Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.

CHIDIST

CHIDIST(x, degrees_freedom)

Calculates the right-tailed chi-squared distribution, often used in hypothesis testing.

CHIINV

CHIINV(probability, degrees_freedom)

Calculates the inverse of the right-tailed chi-squared distribution.

CHISQ.DIST

CHISQ.DIST(x, degrees_freedom, cumulative)

Calculates the left-tailed chi-squared distribution, often used in hypothesis testing.

CHISQ.DIST.RT

CHISQ.DIST.RT(x, degrees_freedom)

Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing.

CHISQ.INV

CHISQ.INV(probability, degrees_freedom)

Calculates the inverse of the left-tailed chi-squared distribution.

CHISQ.INV.RT

CHISQ.INV.RT(probability, degrees_freedom)

Calculates the inverse of the right-tailed chi-squared distribution.

CHISQ.TEST

CHISQ.TEST(observed_range, expected_range)

See CHITEST.

CHITEST

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.

CONFIDENCE

CONFIDENCE(alpha, standard_deviation, pop_size)

See CONFIDENCE.NORM.

CONFIDENCE.NORM

CONFIDENCE.NORM(alpha, standard_deviation, pop_size)

Calculates the width of half the confidence interval for a normal distribution.

CONFIDENCE.T

CONFIDENCE.T(alpha, standard_deviation, size)

Calculates the width of half the confidence interval for a Student’s t-distribution.

CORREL

CORREL(data_y, data_x)

Calculates r, the Pearson product-moment correlation coefficient of a dataset.

COUNT

COUNT(value1, [value2, ...])

Returns a count of the number of numeric values in a dataset.

COUNTA

COUNTA(value1, [value2, ...])

Returns a count of the number of values in a dataset.

COVAR

COVAR(data_y, data_x

)

Calculates the covariance of a dataset.

COVARIANCE.P

COVARIANCE.P(data_y, data_x)

See COVAR.

COVARIANCE.S

COVARIANCE.S(data_y, data_x)

Calculates the covariance of a dataset, where the dataset is a sample of the total population.

CRITBINOM

CRITBINOM(num_trials, prob_success, target_prob)

Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria.

DEVSQ

DEVSQ(value1, value2)

Calculates the sum of squares of deviations based on a sample.

EXPON.DIST

EXPON.DIST(x, LAMBDA, cumulative)

Returns the value of the exponential distribution function with a specified LAMBDA at a specified value.

EXPONDIST

EXPONDIST(x, LAMBDA, cumulative)

See EXPON.DIST.

F.DIST

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.

F.DIST.RT

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.

F.INV

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.

F.INV.RT

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.

F.TEST

F.TEST(range1, range2)

See FTEST.

FDIST

FDIST(x, degrees_freedom1, degrees_freedom2)

See F.DIST.RT.

FINV

FINV(probability, degrees_freedom1, degrees_freedom2)

See F.INV.RT.

FISHER

FISHER(value)

Returns the Fisher transformation of a specified value.

FISHERINV

FISHERINV(value)

Returns the inverse Fisher transformation of a specified value.

FORECAST

FORECAST(x, data_y, data_x)

Calculates the expected y-value for a specified x based on a linear regression of a dataset.

FORECAST.LINEAR

FORECAST.LINEAR(x, data_y, data_x)

See FORECAST.

FTEST

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.

GAMMA

GAMMA(number)

Returns the Gamma function evaluated at the specified value.

GAMMA.DIST

GAMMA.DIST(x, alpha, beta, cumulative)

Calculates the gamma distribution, a two-parameter continuous probability distribution.

GAMMA.INV

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.

GAMMADIST

GAMMADIST(x, alpha, beta, cumulative)

See GAMMA.DIST.

GAMMAINV

GAMMAINV(probability, alpha, beta)

See GAMMA.INV.

GAUSS

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.

GEOMEAN

GEOMEAN(value1, value2)

Calculates the geometric mean of a dataset.

HARMEAN

HARMEAN(value1, value2)

Calculates the harmonic mean of a dataset.

HYPGEOM.DIST

HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)

See HYPGEOMDIST.

HYPGEOMDIST

HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)

Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws.

INTERCEPT

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).

KURT

KURT(value1, value2)

Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset.

LARGE

LARGE(data, n)

Returns the nth largest element from a data set, where n is user-defined.

LOGINV

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.

LOGNORM.DIST

LOGNORM.DIST(x, mean, standard_deviation)

See LOGNORMDIST.

LOGNORM.INV

LOGNORM.INV(x, mean, standard_deviation)

See LOGINV.

LOGNORMDIST

LOGNORMDIST(x, mean, standard_deviation)

Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value.

MARGINOFERROR

MARGINOFERROR(range, confidence)

Calculates the amount of random sampling error given a range of values and a confidence level.

MAX

MAX(value1, [value2, ...])

Returns the maximum value in a numeric dataset.

MAXA

MAXA(value1, value2)

Returns the maximum numeric value in a dataset.

MAXIFS

MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)

Returns the maximum value in a range of cells, filtered by a set of criteria.

MEDIAN

MEDIAN(value1, [value2, ...])

Returns the median value in a numeric dataset.

MIN

MIN(value1, [value2, ...])

Returns the minimum value in a numeric dataset.

MINA

MINA(value1, value2)

Returns the minimum numeric value in a dataset.

MINIFS

MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)

Returns the minimum value in a range of cells, filtered by a set of criteria.

MODE

MODE(value1, [value2, ...])

Returns the most commonly occurring value in a dataset.

MODE.MULT

MODE.MULT(value1, value2)

Returns the most commonly occurring values in a dataset.

MODE.SNGL

MODE.SNGL(value1, [value2, ...])

See MODE.

NEGBINOM.DIST

NEGBINOM.DIST(num_failures, num_successes, prob_success)

See NEGBINOMDIST.

NEGBINOMDIST

NEGBINOMDIST(num_failures, num_successes, prob_success)

Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials.

NORM.DIST

NORM.DIST(x, mean, standard_deviation, cumulative)

See NORMDIST.

NORM.INV

NORM.INV(x, mean, standard_deviation)

See NORMINV.

NORM.S.DIST

NORM.S.DIST(x)

See NORMSDIST.

NORM.S.INV

NORM.S.INV(x)

See NORMSINV.

NORMDIST

NORMDIST(x, mean, standard_deviation, cumulative)

Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.

NORMINV

NORMINV(x, mean, standard_deviation)

Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.

NORMSDIST

NORMSDIST(x)

Returns the value of the standard normal cumulative distribution function for a specified value.

NORMSINV

NORMSINV(x)

Returns the value of the inverse standard normal distribution function for a specified value.

PEARSON

PEARSON(data_y, data_x)

Calculates r, the Pearson product-moment correlation coefficient of a

dataset.

PERCENTILE

PERCENTILE(data, percentile)

Returns the value at a given percentile of a dataset.

PERCENTILE.EXC

PERCENTILE.EXC(data, percentile)

Returns the value at a given percentile of a dataset, exclusive of 0 and 1.

PERCENTILE.INC

PERCENTILE.INC(data, percentile)

See PERCENTILE.

PERCENTRANK

PERCENTRANK(data, value, [significant_digits])

Returns the percentage rank (percentile) of a specified value in a dataset.

PERCENTRANK.EXC

PERCENTRANK.EXC(data, value, [significant_digits])

Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.

PERCENTRANK.INC

PERCENTRANK.INC(data, value, [significant_digits])

Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset.

PERMUTATIONA

PERMUTATIONA(number, number_chosen)

Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects.

PERMUT

PERMUT(n, k)

Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order.

PHI

PHI(x)

The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1.

POISSON

POISSON(x, mean, cumulative)

See POISSON.DIST.

POISSON.DIST

POISSON.DIST(x, mean, [cumulative])

Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean.

PROB

PROB(data, probabilities, low_limit, [high_limit])

Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits.

QUARTILE

QUARTILE(data, quartile_number)

Returns a value nearest to a specified quartile of a dataset.

QUARTILE.EXC

QUARTILE.EXC(data, quartile_number)

Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4.

QUARTILE.INC

QUARTILE.INC(data, quartile_number)

See QUARTILE.

RANK

RANK(value, data, [is_ascending])

Returns the rank of a specified value in a dataset.

RANK.AVG

RANK.AVG(value, data, [is_ascending])

Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned.

RANK.EQ

RANK.EQ(value, data, [is_ascending])

Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned.

RSQ

RSQ(data_y, data_x)

Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.

SKEW

SKEW(value1, value2)

Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.

SKEW.P

SKEW.P(value1, value2)

Calculates the skewness of a dataset that represents the entire population.

SLOPE

SLOPE(data_y, data_x)

Calculates the slope of the line resulting from linear regression of a dataset.

SMALL

SMALL(data, n)

Returns the nth smallest element from a data set, where n is user-defined.

STANDARDIZE

STANDARDIZE(value, mean, standard_deviation)

Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution.

STDEV

STDEV(value1, [value2, ...])

Calculates the standard deviation based on a sample.

STDEV.P

STDEV.P(value1, [value2, ...])

See STDEVP.

STDEV.S

STDEV.S(value1, [value2, ...])

See STDEV.

STDEVA

STDEVA(value1, value2)

Calculates the standard deviation based on a sample, setting text

to the value 0.

STDEVP

STDEVP(value1, value2)

Calculates the standard deviation based on an entire population.

STDEVPA

STDEVPA(value1, value2)

Calculates the standard deviation based on an entire population, setting text to the value 0.

STEYX

STEYX(data_y, data_x)

Calculates the standard error of the predicted y-value for each x in the regression of a dataset.

T.DIST

T.DIST(x, degrees_freedom, cumulative)

Returns the right tailed Student distribution for a value x.

T.DIST.2T

T.DIST.2T(x, degrees_freedom)

Returns the two tailed Student distribution for a value x.

T.DIST.RT

T.DIST.RT(x, degrees_freedom)

Returns the right tailed Student distribution for a value x.

T.INV

T.INV(probability, degrees_freedom)

Calculates the negative inverse of the one-tailed TDIST function.

T.INV.2T

T.INV.2T(probability, degrees_freedom)

Calculates the inverse of the two-tailed TDIST function.

T.TEST

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.

TDIST

TDIST(x, degrees_freedom, tails)

Calculates the probability for Student's t-distribution with a given input (x).

TINV

TINV(probability, degrees_freedom)

See T.INV.2T.

TRIMMEAN

TRIMMEAN(data, exclude_proportion)

Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset.

TTEST

TTEST(range1, range2, tails, type)

See T.TEST.

VAR

VAR(value1, [value2, ...])

Calculates the variance based on a sample.

VAR.P

VAR.P(value1, [value2, ...])

See VARP.

VAR.S

VAR.S(value1, [value2, ...])

See VAR.

VARA

VARA(value1, value2)

Calculates an estimate of variance based on a sample, setting text to the value 0.

VARP

VARP(value1, value2)

Calculates the variance based on an entire population.

VARPA

VARPA(value1, value2,...)

Calculates the variance based on an entire population, setting text to the value 0.

WEIBULL

WEIBULL(x, shape, scale, cumulative)

Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale.

WEIBULL.DIST

WEIBULL.DIST(x, shape, scale, cumulative)

See WEIBULL.

Z.TEST

Z.TEST(data, value, [standard_deviation])

Returns the one-tailed P-value of a Z-test with standard distribution.

ZTEST

ZTEST(data, value, [standard_deviation])

See Z.TEST.

ARABIC

ARABIC(roman_numeral)

Computes the value of a Roman numeral.

ASC

ASC(text)

Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged.

CHAR

CHAR(table_number)

Convert a number into a character according to the current Unicode table.

CLEAN

CLEAN(text)

Returns the text with the non-printable ASCII characters removed.

CODE

CODE(string)

Returns the numeric Unicode map value of the first character in the string provided.

CONCATENATE

CONCATENATE(string1, [string2, ...])

Appends strings to one another.

DOLLAR

DOLLAR(number, [number_of_places])

Formats a number into the locale-specific currency format.

EXACT

EXACT(string1, string2)

Tests whether two strings are identical.

FIND

FIND(search_for, text_to_search, [starting_at])

Returns the position at which a string is first found within text.

FINDB

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

FIXED(number, [number_of_places], [suppress_separator])

Formats a number with a fixed number of decimal places.

JOIN

JOIN(delimiter, value_or_array1, [value_or_array2, ...])

Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.

LEFT

LEFT(string, [number_of_characters])

Returns a substring from the beginning of a specified string.

LEFTB

LEFTB(string, num_of_bytes)

Returns the left portion of a string up to a certain number of bytes.

LEN

LEN(text)

Returns the length of a string.

LENB

LENB(string)

Returns the length of a string in bytes.

LOWER

LOWER(text)

Converts a specified string to lowercase.

MID

MID(string, starting_at, extract_length)

Returns a segment of a string.

MIDB

MIDB(string)

Returns a section of a string starting at a given character and up to a specified number of bytes.

PROPER

PROPER(text_to_capitalize)

Capitalizes each word in a specified string.

REGEXEXTRACT

REGEXEXTRACT(text, regular_expression)

Extracts matching substrings according to a regular expression.

REGEXMATCH

REGEXMATCH(text, regular_expression)

Determines whether a piece of text matches a regular expression.

REGEXREPLACE

REGEXREPLACE(text, regular_expression, replacement)

Replaces part of a text string with a different text string using regular expressions.

REPLACE

REPLACE(text, position, length, new_text)

Replaces part of a text string with a different text string.

REPLACEB

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

REPT(text_to_repeat, number_of_repetitions)

Returns specified text repeated a number of times.

RIGHT

RIGHT(string, [number_of_characters])

Returns a substring from the end of a specified string.

RIGHTB

RIGHTB(string, num_of_bytes)

Returns the right portion of a string up to a certain number of bytes.

ROMAN

ROMAN(number, [rule_relaxation])

Formats a number in Roman numerals.

SEARCH

SEARCH(search_for, text_to_search, [starting_at])

Returns the position at which a string is first found within text.

SEARCHB

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

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

SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])

Replaces existing text with new text in a string.

T

T(value)

Returns string arguments as text.

TEXT

TEXT(number, format)

Converts a number into text according

to a specified format.

TEXTJOIN

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.

TRIM

TRIM(text)

Removes leading and trailing spaces in a specified string.

UNICHAR

UNICHAR(number)

Returns the Unicode character for a number.

UNICODE

UNICODE(text)

Returns the decimal Unicode value of the first character of the text.

UPPER

UPPER(text)

Converts a specified string to uppercase.

VALUE

VALUE(text)

Converts a string in any of the date, time, or number formats that Google Sheets understands into a number.

ENCODEURL

ENCODEURL(text)

Encodes a string of text for the purpose of using in a URL query.

HYPERLINK

HYPERLINK(url, [link_label])

Creates a hyperlink inside a cell.

IMPORTDATA

IMPORTDATA(url)

Imports data at a given URL in .csv (comma-separated value) or .tsv (tab-separated value) format.

IMPORTFEED

IMPORTFEED(url, [query], [headers], [num_items])

Imports an RSS or ATOM feed.

IMPORTHTML

IMPORTHTML(url, query, index)

Imports data from a table or list within an HTML page.

IMPORTRANGE

IMPORTRANGE(spreadsheet_url, range_string)

Imports a range of cells from a specified spreadsheet.

IMPORTXML

IMPORTXML(url, xpath_query)

Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.

ISURL

ISURL(value)

Checks whether a value is a valid URL.