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

ERROR.TYPE(reference)

Rounds a number up to the nearest even integer.

EVEN(value)

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

EXPON.DIST(x, LAMBDA, cumulative)

See EXPON.DIST

EXPONDIST(x, LAMBDA, cumulative)

Calculates the left-tailed F probability distribution (degree of diversity) for two data sets wit...

F.DIST(x, degrees_freedom1, degrees_freedom2, cumulative)

Calculates the right-tailed F probability distribution (degree of diversity) for two data sets wi...

F.DIST.RT(x, degrees_freedom1, degrees_freedom2)

Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Sned...

F.INV(probability, degrees_freedom1, degrees_freedom2)

Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Sne...

F.INV.RT(probability, degrees_freedom1, degrees_freedom2)

See FTEST.

F.TEST(range1, range2)

Returns the factorial of a number.

FACT(value)

Returns the "double factorial" of a number.

FACTDOUBLE(value)

Returns the logical value `FALSE`.

FALSE()

See F.DIST.RT.

FDIST(x, degrees_freedom1, degrees_freedom2)

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

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

FINDB(search_for, text_to_search, [starting_at])

See F.INV.RT

FINV(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 num...

FLOOR.MATH(number, [significance], [mode])

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

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)

Returns the probability associated with an F-test for equality of variances. Determines whether t...

FTEST(range1, range2)

Calculates the future value of an annuity investment based on constant-amount periodic payments a...

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

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)

The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function fo...

GAMMA.INV(probability, alpha, beta)

See GAMMA.DIST

GAMMADIST(x, alpha, beta, cumulative)

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

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

GESTEP(value, [step])

Extracts an aggregated value from a pivot table that corresponds to the specified row and column ...

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

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