## 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