Returns the the logarithm of a number given a base.

LOG(value, base)

Returns the the logarithm of a number, base e (Euler's number).

LN(value)

Given partial data about a linear trend, calculates various parameters about the ideal linear tre...

LINEST(known_data_y, [known_data_x], [calculate_b], [verbose])

Returns the length of a string in bytes.".

LENB(string)

Assigns names to intermediate calculated values and returns the result of a final formula express...

LET(name1, value_expression1, [name2, ...], [value_expression2, ...], formula_expression)

Returns the left portion of a string up to a certain number of bytes..

LEFTB(string, num_of_bytes)

Returns the least common multiple of one or more integers.

LCM(value1, value2)

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

LARGE(data, n)

Creates and returns a custom function with a set of names and a formula_expression that uses them...

LAMBDA(name, formula_expression)

Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakednes...

KURT(value1, value2)

Checks whether a value is a valid cell reference.

ISREF(value)

The ISPMT function calculates the interest paid during a particular period of an investment..

ISPMT(rate, period, number_of_periods, present_value)

Returns the number of the ISO week of the year where the provided date falls.

ISOWEEKNUM(date)

Checks whether the provided value is odd.

ISODD(value)

See CEILING.PRECISE

ISO.CEILING(number, [significance])

Checks whether a value is a number.

ISNUMBER(value)

Checks whether a value is non-textual.

ISNONTEXT(value)

Checks whether a value is the error `#N/A`.

ISNA(value)

Checks whether a value is `TRUE` or `FALSE`.

ISLOGICAL(value)

Checks whether the provided value is even.

ISEVEN(value)

Checks whether a value is an error.

ISERROR(value)

Checks whether a value is an error other than `#N/A`.

ISERR(value)

Returns whether a value is a date..

ISDATE(value)

Checks whether a provided number is between two other numbers either inclusively or exclusively.

ISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive)

Calculates the internal rate of return on an investment based on a series of periodic cash flows.

IRR(cashflow_amounts, [rate_guess])

Calculates the payment on interest for an investment based on constant-amount periodic payments a...

IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])

Calculates the effective interest rate generated when an investment is purchased at one price and...

INTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention])

Returns the formula as a string..

FORMULATEXT(cell)

See FORECAST

FORECAST.LINEAR(x, data_y, data_x)

Calculates the expected y-value for a specified x based on a linear regression of a dataset.

FORECAST(x, data_y, data_x)

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

FLOOR.PRECISE(number, [significance])

Rounds a number down to the nearest integer multiple of specified significance, with negative num...

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

Rounds a number down to the nearest integer multiple of specified significance.

FLOOR(value, [factor])

Formats a number with a fixed number of decimal places.

FIXED(number, [number_of_places], [suppress_separator])

Returns the inverse Fisher transformation of a specified value.

FISHERINV(value)

Returns the Fisher transformation of a specified value.

FISHER(value)

See F.INV.RT

FINV(probability, degrees_freedom1, degrees_freedom2)

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

FDIST(x, degrees_freedom1, degrees_freedom2)

Returns the logical value `FALSE`.

FALSE()

Returns the "double factorial" of a number.

FACTDOUBLE(value)

Returns the factorial of a number.

FACT(value)

See FTEST.

F.TEST(range1, range2)

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

F.INV.RT(probability, 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 right-tailed F probability distribution (degree of diversity) for two data sets wi...

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

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

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

See EXPON.DIST

EXPONDIST(x, LAMBDA, cumulative)