Calculates the probability of drawing a certain number of successes (or a maximum number of succe...

BINOMDIST(num_successes, num_trials, prob_success, cumulative)

See CRITBINOM

BINOM.INV(num_trials, prob_success, target_prob)

See BINOMDIST

BINOM.DIST(num_successes, num_trials, prob_success, cumulative)

Converts a signed binary number to signed octal format.

BIN2OCT(signed_binary_number, [significant_digits])

Converts a signed binary number to signed hexadecimal format.

BIN2HEX(signed_binary_number, [significant_digits])

Converts a signed binary number to decimal format.

BIN2DEC(signed_binary_number)

Returns the value of the inverse log-normal cumulative distribution with given mean and standard ...

LOGINV(x, mean, standard_deviation)

Calculates the y-value at which the line resulting from linear regression of a dataset will inter...

INTERCEPT(data_y, data_x)

Rounds a number down to the nearest integer that is less than or equal to it.

INT(value)

Returns the hyperbolic tangent of the given complex number. For example, a given complex number "...

IMTANH(number)

Returns the tangent of the given complex number..

IMTAN(number)

Returns the sum of a series of complex numbers.

IMSUM(value1, [value2, ...])

Returns the difference between two complex numbers.

IMSUB(first_number, second_number)

Computes the square root of a complex number.

IMSQRT(complex_number)

Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+y...

IMSINH(number)

Returns the sine of the given complex number..

IMSIN (number)

Returns the hyperbolic secant of the given complex number. For example, a given complex number "x...

IMSECH(number)

Returns the secant of the given complex number. For example, a given complex number "x+yi" return...

IMSEC(number)

Returns the real coefficient of a complex number.

IMREAL(complex_number)

Returns the result of multiplying a series of complex numbers together.

IMPRODUCT(factor1, [factor2, ...])

Returns a complex number raised to a power.

IMPOWER(complex_base, exponent)

Imports data from a table or list within an HTML page.

IMPORTHTML(url, query, index)

Imports a RSS or ATOM feed.

IMPORTFEED(url, [query], [headers], [num_items])

Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.

IMPORTDATA(url)

Returns the logarithm of a complex number with base 2..

IMLOG2(value)

Returns the logarithm of a complex number with base 10..

IMLOG10(value)

Returns the logarithm of a complex number for a specified base..

IMLOG(value, base)

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

IMLN(complex_value)

Returns Euler's number, e (~2.718) raised to a complex power..

IMEXP(exponent)

Returns one complex number divided by another.

IMDIV(dividend, divisor)

Returns the hyperbolic cosecant of the given complex number. For example, a given complex number ...

IMCSCH(number)

Returns the cosecant of the given complex number..

IMCSC(number)

Returns the hyperbolic cotangent of the given complex number. For example, a given complex number...

IMCOTH(number)

Returns the cotangent of the given complex number. For example, a given complex number "x+yi" ret...

IMCOT(number)

Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x...

IMCOSH(number)

Given partial data about an exponential growth curve, calculates various parameters about the bes...

LOGEST(known_data_y, [known_data_x], [b], [verbose])

Returns the the logarithm of a number, base 10.

LOG10(value)

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)

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)