Excel Function Reference

Functions alphabetically | Functions by category

Functions are sorted from A to Z, click on a letter to quickly navigate in the table below.

Click on a link to get more detailed information about a function.

INDIRECT function Returns the cell reference based on a text string and shows the content of that cell reference. Lookup and reference
INFO function Returns information about the current operating environment, file path, number of active worksheets, Excel version etc. Information
INT function Removes the decimal part from positive numbers and returns the whole number (integer) except negative values are rounded down to the nearest integer. Math and trigonometry
INTERCEPT function Returns a value representing the y-value where a line intersects the y-axis. Statistical
IPMT function Calculates the interest payment for a specific period for an investment based on repeated constant payments and a constant interest rate. Financial
ISBLANK function Returns TRUE if the argument is an empty cell, returns FALSE if not. Information
ISERR function Returns TRUE if a cell returns an error, except error value #N/A. Information
ISERROR function Returns TRUE if a cell contains an error. Information
ISFORMULA function Returns TRUE if a cell contains a formula, FALSE if text, number or boolean value. Information
ISLOGICAL function Returns TRUE if value is boolean. A boolean value is either TRUE or FALSE. Information
ISNA function Returns TRUE if value is a #N/A error. Information
ISNONTEXT function Returns TRUE if value is not text, also returns TRUE if cell is empty. Information
ISNUMBER function Checks if a value is a number, returns TRUE or FALSE. Information
ISODD function Returns TRUE if a cell contains an odd number, FALSE if even number. Information
ISPMT function Calculates the interest paid during a specific period of an investment. Financial
ISREF function Returns TRUE if value refers to a reference. Information
ISTEXT function Returns TRUE if argument is text. Information
LARGE function Calculates the k-th largest value from an array of numbers. Statistical
LCM function Calculates the least common multiple. The least common multiple is the smallest positive integer that is a multiple of all integer arguments. Use the LCM function to find fractions with different denominators. Math and trigonometry
LEFT function Extracts a specific number of characters always starting from the left. Text
LEN function Returns the number of characters in a cell value. Text
LINEST function Returns an array of values representing the parameters of a straight line based on the "least squares" method. Statistical
LN function Calculates the natural logarithm of a number. Natural logarithms are based on the constant e. Math and trigonometry
LOG function Calculates the logarithm of a number to a specific base. Math and trigonometry
LOG10 function Calculates the logarithm of a number using the base 10. Math and trigonometry
LOGEST function Statistical
LOGNORM.DIST function Calculates the lognormal distribution of argument x, based on a normally distributed ln(x) with the arguments of mean and standard_dev. Statistical
LOGNORMDIST function Calculates the cumulative lognormal distribution of argument x, based on a normally distributed ln(x) with the arguments of mean and standard_dev. Compatibility
LOOKUP function Find a value in a cell range and return a corresponding value on the same row. Lookup and reference
LOWER function Converts a value to lower case letters. Text
MATCH function Returns the relative position of an item in an array that matches a specified value in a specific order. Lookup and reference

Back to top