Page 6 of 11
IMSUM
Returns the sum of a series of complex numbers.
IMSUM(value1, [value2, ...])
IMTAN
Returns the tangent of the given complex number..
IMTAN(number)
IMTANH
Returns the hyperbolic tangent of the given complex number. For example, a given complex number "...
IMTANH(number)
INDEX
Returns the content of a cell, specified by row and column offset.
INDEX(reference, [row], [column])
INDIRECT
Returns a cell reference specified by a string.
INDIRECT(cell_reference_as_string, [is_A1_notation])
INT
Rounds a number down to the nearest integer that is less than or equal to it.
INT(value)
INTERCEPT
Calculates the y-value at which the line resulting from linear regression of a dataset will inter...
INTERCEPT(data_y, data_x)
INTRATE
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])
IPMT
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])
IRR
Calculates the internal rate of return on an investment based on a series of periodic cash flows.
IRR(cashflow_amounts, [rate_guess])
ISBETWEEN
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)
ISBLANK
Checks whether the referenced cell is empty.
ISBLANK(value)
ISDATE
Returns whether a value is a date..
ISDATE(value)
ISEMAIL
Checks whether a value is a valid email address.
ISEMAIL(value)
ISERR
Checks whether a value is an error other than `#N/A`.
ISERR(value)
ISERROR
Checks whether a value is an error.
ISERROR(value)
ISEVEN
Checks whether the provided value is even.
ISEVEN(value)
ISFORMULA
Checks whether a formula is in the referenced cell.
ISFORMULA(cell)
ISLOGICAL
Checks whether a value is `TRUE` or `FALSE`.
ISLOGICAL(value)
ISNA
Checks whether a value is the error `#N/A`.
ISNA(value)
ISNONTEXT
Checks whether a value is non-textual.
ISNONTEXT(value)
ISNUMBER
Checks whether a value is a number.
ISNUMBER(value)
ISO.CEILING
See CEILING.PRECISE
ISO.CEILING(number, [significance])
ISODD
Checks whether the provided value is odd.
ISODD(value)
ISOWEEKNUM
Returns the number of the ISO week of the year where the provided date falls.
ISOWEEKNUM(date)
ISPMT
The ISPMT function calculates the interest paid during a particular period of an investment..
ISPMT(rate, period, number_of_periods, present_value)
ISREF
Checks whether a value is a valid cell reference.
ISREF(value)
ISTEXT
Checks whether a value is text.
ISTEXT(value)
ISURL
Checks whether a value is a valid URL.
ISURL(value)
JOIN
Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.
JOIN(delimiter, value_or_array1, [value_or_array2, ...])
KURT
Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakednes...
KURT(value1, value2)
LAMBDA
Creates and returns a custom function with a set of names and a formula_expression that uses them...
LAMBDA(name, formula_expression)
LARGE
Returns the nth largest element from a data set, where n is user-defined.
LARGE(data, n)
LCM
Returns the least common multiple of one or more integers.
LCM(value1, value2)
LEFT
Returns a substring from the beginning of a specified string.
LEFT(string, [number_of_characters])
LEFTB
Returns the left portion of a string up to a certain number of bytes..
LEFTB(string, num_of_bytes)
LEN
Returns the length of a string.
LEN(text)
LENB
Returns the length of a string in bytes.".
LENB(string)
LET
Assigns names to intermediate calculated values and returns the result of a final formula express...
LET(name1, value_expression1, [name2, ...], [value_expression2, ...], formula_expression)
LINEST
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])
LN
Returns the the logarithm of a number, base e (Euler's number).
LN(value)
LOG
Returns the the logarithm of a number given a base.
LOG(value, base)
LOG10
Returns the the logarithm of a number, base 10.
LOG10(value)
LOGEST
Given partial data about an exponential growth curve, calculates various parameters about the bes...
LOGEST(known_data_y, [known_data_x], [b], [verbose])
LOGINV
Returns the value of the inverse log-normal cumulative distribution with given mean and standard ...
LOGINV(x, mean, standard_deviation)
LOGNORM.DIST
See LOGNORMDIST
LOGNORM.DIST(x, mean, standard_deviation)
LOGNORM.INV
See LOGINV
LOGNORM.INV(x, mean, standard_deviation)
LOGNORMDIST
Returns the value of the log-normal cumulative distribution with given mean and standard deviatio...
LOGNORMDIST(x, mean, standard_deviation)