Google Sheets Formulas List: 500+ Functions with

LOOKUP Looks through a row or column for a key and returns the value of the cell in a result range locat... LOOKUP(search_key, search_range|search_result_array, [result_range])

LOWER Converts a specified string to lowercase. LOWER(text)

LT Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equ... LT(value1, value2)

LTE Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. ... LTE(value1, value2)

MAKEARRAY Returns an array of specified dimensions with values calculated by application of a LAMBDA function. MAKEARRAY(rows, columns, LAMBDA)

MAP Maps each value in the given arrays to a new value by application of a LAMBDA function to each va... MAP(array1, [array2, ...], LAMBDA)

MARGINOFERROR Calculates the amount of random sampling error given a range of values and a confidence level. MARGINOFERROR(range, confidence)

MATCH Returns the relative position of an item in a range that matches a specified value. MATCH(search_key, range, [search_type])

MAX Returns the maximum value in a numeric dataset. MAX(value1, [value2, ...])

MAXA Returns the maximum numeric value in a dataset. MAXA(value1, value2)

MAXIFS Returns the maximum value in a range of cells, filtered by a set of criteria.. MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)

MDETERM Returns the matrix determinant of a square matrix specified as an array or range. MDETERM(square_matrix)

MDURATION Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Tr... MDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])

MEDIAN Returns the median value in a numeric dataset. MEDIAN(value1, [value2, ...])

MID Returns a segment of a string. MID(string, starting_at, extract_length)

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

MIN Returns the minimum value in a numeric dataset. MIN(value1, [value2, ...])

MINA Returns the minimum numeric value in a dataset. MINA(value1, value2)

MINIFS Returns the minimum value in a range of cells, filtered by a set of criteria.. MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)

MINUS Returns the difference of two numbers. Equivalent to the `-` operator. MINUS(value1, value2)

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

MINVERSE Returns the multiplicative inverse of a square matrix specified as an array or range. MINVERSE(square_matrix)

MIRR Calculates the modified internal rate of return on an investment based on a series of periodic ca... MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)

MMULT Calculates the matrix product of two matrices specified as arrays or ranges. MMULT(matrix1, matrix2)

MOD Returns the result of the modulo operator, the remainder after a division operation. MOD(dividend, divisor)

MODE Returns the most commonly occurring value in a dataset. MODE(value1, [value2, ...])

MODE.MULT Returns the most commonly occurring values in a dataset.. MODE.MULT(value1, value2)

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

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

MROUND Rounds one number to the nearest integer multiple of another. MROUND(value, factor)

MULTINOMIAL Returns the factorial of the sum of values divided by the product of the values' factorials. MULTINOMIAL(value1, value2)

MULTIPLY Returns the product of two numbers. Equivalent to the `*` operator. MULTIPLY(factor1, factor2)

MUNIT Returns a unit matrix of size dimension x dimension.. MUNIT(dimension)

N Returns the argument provided as a number. N(value)

NA Returns the "value not available" error, `#N/A`. NA()

NE Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `&l... NE(value1, value2)

NEGBINOM.DIST See NEGBINOMDIST NEGBINOM.DIST(num_failures, num_successes, prob_success)

NEGBINOMDIST Calculates the probability of drawing a certain number of failures before a certain number of suc... NEGBINOMDIST(num_failures, num_successes, prob_success)

NETWORKDAYS Returns the number of net working days between two provided days. NETWORKDAYS(start_date, end_date, [holidays])

NETWORKDAYS.INTL Returns the number of net working days between two provided days excluding specified weekend days... NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

NOMINAL Calculates the annual nominal interest rate given the effective rate and number of compounding pe... NOMINAL(effective_rate, periods_per_year)

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

NORM.INV See NORMINV NORM.INV(x, mean, standard_deviation)

NORM.S.DIST See NORMSDIST NORM.S.DIST(x)

NORM.S.INV See NORMSINV NORM.S.INV(x)

NORMDIST Returns the value of the normal distribution function (or normal cumulative distribution function... NORMDIST(x, mean, standard_deviation, cumulative)

NORMINV Returns the value of the inverse normal distribution function for a specified value, mean, and st... NORMINV(x, mean, standard_deviation)

NORMSDIST Returns the value of the standard normal cumulative distribution function for a specified value. NORMSDIST(x)

Better Sheets

Page 7 of 11