79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

Hey there! Register a new account to access the full suite of features, tutorials, and more..

Most Popular Formulas

IF

Powerful and mysterious. Use IF() to make your spreadsheets gateways. Learn how to use IF in Google Sheets. Also check out it's oft-partner ISBLANK()

FILTER

the FILTER() formula in Google Sheets allows you to filter data based on a set of criteria. Learn how to use FILTER in Google Sheets. Also check out it's possible combination alternative: INDEX/SORT.

COUNTIF

Count the number of cells that meet a certain criteria. Learn how to use COUNTIF in Google Sheets. Also check out it's possible parter: UNIQUE()

Most Misused Formulas

VLOOKUP

Powerful vlookup and easy to use. Learn how to use VLOOKUP in Google Sheets. Also check out it's possible alternative: INDEX/MATCH.

SUMIF

Don't know the syntax, or how to use SUMIF? Learn how to use SUMIF in Google Sheets. Also check out it's possible alternative: COUNTIF. Depending on what you're trying to do, SUMIF could be your solution or not.

CONCATENATE

Probably the most easily misspelled formula in all of Google Sheets. Learn how to use CONCATENATE in Google Sheets. Also check out it's possible alternative: JOIN.

504Formulas

Every Formula in Google Sheets, From ABS to ZTEST, including Vlookup and, my favorite, IF()

Tests whether two strings are identical.
EXACT(string1, string2)
Returns Euler's number, e (~2.718) raised to a power.
EXP(exponent)
Returns the value of the exponential distribution function with a specified LAMBDA at a specified value..
EXPON.DIST(x, LAMBDA, cumulative)
See EXPON.DIST
EXPONDIST(x, LAMBDA, cumulative)
Returns the factorial of a number.
FACT(value)
Returns the "double factorial" of a number.
FACTDOUBLE(value)
Returns the logical value `FALSE`.
FALSE()
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(x, degrees_freedom1, degrees_freedom2, cumulative)
See F.DIST.RT.
FDIST(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.DIST.RT(x, degrees_freedom1, degrees_freedom2)
Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.
FILTER(range, condition1, [condition2])
Returns the position at which a string is first found within text.
FIND(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.
FINDB(search_for, text_to_search, [starting_at])
Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution.
F.INV(probability, degrees_freedom1, degrees_freedom2)
See F.INV.RT
FINV(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.INV.RT(probability, degrees_freedom1, degrees_freedom2)
Returns the Fisher transformation of a specified value.
FISHER(value)
Returns the inverse Fisher transformation of a specified value.
FISHERINV(value)
Formats a number with a fixed number of decimal places.
FIXED(number, [number_of_places], [suppress_separator])
Flattens all the values from one or more ranges into a single column.
FLATTEN(range1,[range2,...])
Rounds a number down to the nearest integer multiple of specified significance.
FLOOR(value, [factor])
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.MATH(number, [significance], [mode])
The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance..
FLOOR.PRECISE(number, [significance])
Calculates the expected y-value for a specified x based on a linear regression of a dataset.
FORECAST(x, data_y, data_x)
See FORECAST
FORECAST.LINEAR(x, data_y, data_x)
Returns the formula as a string..
FORMULATEXT(cell)
Calculates the frequency distribution of a one-column array into specified classes.
FREQUENCY(data, classes)
See FTEST.
F.TEST(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.
FTEST(range1, range2)
Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.
FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])
Calculates the future value of some principal based on a specified series of potentially varying interest rates.
FVSCHEDULE(principal, rate_schedule)
Returns the Gamma function evaluated at the specified value..
GAMMA(number)
Calculates the gamma distribution, a two-parameter continuous probability distribution.
GAMMA.DIST(x, alpha, beta, cumulative)
See GAMMA.DIST
GAMMADIST(x, alpha, beta, cumulative)
The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function for the specified probability and alpha and beta parameters..
GAMMA.INV(probability, alpha, beta)
See GAMMA.INV.
GAMMAINV(probability, alpha, beta)
Returns the the logarithm of a specified Gamma function, base e (Euler's number).
GAMMALN(value)
See GAMMALN
GAMMALN.PRECISE(value)
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..
GAUSS(z)
Returns the greatest common divisor of one or more integers.
GCD(value1, value2)
Calculates the geometric mean of a dataset.
GEOMEAN(value1, value2)
Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise. If no step value is provided then the default value of 0 will be used..
GESTEP(value, [step])
Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings.
GETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]
Fetches current or historical securities information from Google Finance.
GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
Translates text from one language into another
GOOGLETRANSLATE(text, [source_language], [target_language])
Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values.
GROWTH(known_data_y, [known_data_x], [new_data_x], [b])
Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator.
GT(value1, value2)
Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator.
GTE(value1, value2)

Displaying items 145-192 of 504 in total