Page 4 of 11
ERFC.PRECISE
See ERFC
ERFC.PRECISE(z)
ERROR.TYPE
Returns a number corresponding to the error value in a different cell.
ERROR.TYPE(reference)
EVEN
Rounds a number up to the nearest even integer.
EVEN(value)
EXACT
Tests whether two strings are identical.
EXACT(string1, string2)
EXP
Returns Euler's number, e (~2.718) raised to a power.
EXP(exponent)
EXPON.DIST
Returns the value of the exponential distribution function with a specified LAMBDA at a specified...
EXPON.DIST(x, LAMBDA, cumulative)
EXPONDIST
See EXPON.DIST
EXPONDIST(x, LAMBDA, cumulative)
F.DIST
Calculates the left-tailed F probability distribution (degree of diversity) for two data sets wit...
F.DIST(x, degrees_freedom1, degrees_freedom2, cumulative)
F.DIST.RT
Calculates the right-tailed F probability distribution (degree of diversity) for two data sets wi...
F.DIST.RT(x, degrees_freedom1, degrees_freedom2)
F.INV
Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Sned...
F.INV(probability, degrees_freedom1, degrees_freedom2)
F.INV.RT
Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Sne...
F.INV.RT(probability, degrees_freedom1, degrees_freedom2)
F.TEST
See FTEST.
F.TEST(range1, range2)
FACT
Returns the factorial of a number.
FACT(value)
FACTDOUBLE
Returns the "double factorial" of a number.
FACTDOUBLE(value)
FALSE
Returns the logical value `FALSE`.
FALSE()
FDIST
See F.DIST.RT.
FDIST(x, degrees_freedom1, degrees_freedom2)
FILTER
Returns a filtered version of the source range, returning only rows or columns which meet the spe...
FILTER(range, condition1, [condition2])
FIND
Returns the position at which a string is first found within text.
FIND(search_for, text_to_search, [starting_at])
FINDB
Returns the position at which a string is first found within text counting each double-character ...
FINDB(search_for, text_to_search, [starting_at])
FINV
See F.INV.RT
FINV(probability, degrees_freedom1, degrees_freedom2)
FISHER
Returns the Fisher transformation of a specified value.
FISHER(value)
FISHERINV
Returns the inverse Fisher transformation of a specified value.
FISHERINV(value)
FIXED
Formats a number with a fixed number of decimal places.
FIXED(number, [number_of_places], [suppress_separator])
FLATTEN
Flattens all the values from one or more ranges into a single column.
FLATTEN(range1,[range2,...])
FLOOR
Rounds a number down to the nearest integer multiple of specified significance.
FLOOR(value, [factor])
FLOOR.MATH
Rounds a number down to the nearest integer multiple of specified significance, with negative num...
FLOOR.MATH(number, [significance], [mode])
FLOOR.PRECISE
The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified s...
FLOOR.PRECISE(number, [significance])
FORECAST
Calculates the expected y-value for a specified x based on a linear regression of a dataset.
FORECAST(x, data_y, data_x)
FORECAST.LINEAR
See FORECAST
FORECAST.LINEAR(x, data_y, data_x)
FORMULATEXT
Returns the formula as a string..
FORMULATEXT(cell)
FREQUENCY
Calculates the frequency distribution of a one-column array into specified classes.
FREQUENCY(data, classes)
FTEST
Returns the probability associated with an F-test for equality of variances. Determines whether t...
FTEST(range1, range2)
FV
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])
FVSCHEDULE
Calculates the future value of some principal based on a specified series of potentially varying ...
FVSCHEDULE(principal, rate_schedule)
GAMMA
Returns the Gamma function evaluated at the specified value..
GAMMA(number)
GAMMA.DIST
Calculates the gamma distribution, a two-parameter continuous probability distribution.
GAMMA.DIST(x, alpha, beta, cumulative)
GAMMA.INV
The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function fo...
GAMMA.INV(probability, alpha, beta)
GAMMADIST
See GAMMA.DIST
GAMMADIST(x, alpha, beta, cumulative)
GAMMAINV
See GAMMA.INV.
GAMMAINV(probability, alpha, beta)
GAMMALN
Returns the the logarithm of a specified Gamma function, base e (Euler's number).
GAMMALN(value)
GAMMALN.PRECISE
See GAMMALN
GAMMALN.PRECISE(value)
GAUSS
The GAUSS function returns the probability that a random variable, drawn from a normal distributi...
GAUSS(z)
GCD
Returns the greatest common divisor of one or more integers.
GCD(value1, value2)
GEOMEAN
Calculates the geometric mean of a dataset.
GEOMEAN(value1, value2)
GESTEP
Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise...
GESTEP(value, [step])
GETPIVOTDATA
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, ...]
GOOGLEFINANCE
Fetches current or historical securities information from Google Finance.
GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
GOOGLETRANSLATE
Translates text from one language into another
GOOGLETRANSLATE(text, [source_language], [target_language])