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])

The IMCOS function returns the cosine of the given complex number..

IMCOS(number)

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)

Returns the value of the exponential distribution function with a specified LAMBDA at a specified...

EXPON.DIST(x, LAMBDA, cumulative)

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

EXP(exponent)

Tests whether two strings are identical.

EXACT(string1, string2)

Rounds a number up to the nearest even integer.

EVEN(value)

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

ERROR.TYPE(reference)

See ERFC

ERFC.PRECISE(z)

Returns the complementary Gauss error function of a value.

ERFC(z)

Returns the complex conjugate of a number.

IMCONJUGATE(number)

The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given com...

IMARGUMENT(number)

Returns the imaginary coefficient of a complex number.

IMAGINARY(complex_number)

Returns absolute value of a complex number.

IMABS(number)