Google Sheets function list

Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. These functions can be used to create formulas that manipulate data and calculate strings and numbers.

Here's a list of all the functions available in each category. When using them, don't forget to add quotation marks around all function components made of alphabetic characters that aren't referring to cells or columns.

Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more

Financial

MIRR

MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)

Calculates the modified internal rate of return on an investment based on a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income. Learn more

Financial

NOMINAL

NOMINAL(effective_rate, periods_per_year)

Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year. Learn more

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

Statistical

CHIDIST

CHIDIST(x, degrees_freedom)

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

Statistical

CHIINV

CHIINV(probability, degrees_freedom)

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

Statistical

CHISQ.DIST

CHISQ.DIST(x, degrees_freedom, cumulative)

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

Statistical

CHISQ.DIST.RT

CHISQ.DIST.RT(x, degrees_freedom)

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

Statistical

CHISQ.INV

CHISQ.INV(probability, degrees_freedom)

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

Statistical

CHISQ.INV.RT

CHISQ.INV.RT(probability, degrees_freedom)

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

Statistical

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. Learn more

Calculates the left-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution. Learn more

Statistical

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. Learn more

Statistical

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. Learn more

Statistical

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. Learn more

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

Statistical

INTERCEPT

INTERCEPT(data_y, data_x)

Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0). Learn more

Statistical

KURT

KURT(value1, value2)

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

Statistical

LARGE

LARGE(data, n)

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

Statistical

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. Learn more

Statistical

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. Learn more