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

 F.TEST function Calculates the two-tailed probability from an F-test Statistical FACT function Returns the factorial of a number. Math and trigonometry FACTDOUBLE function Returns the double factorial of a number. Math and trigonometry FALSE function Returns the logical (boolean) value FALSE. Logical FDIST function Calculates the F probability of the right-tailed distribution for two tests. Compatibility FIND function Returns the position of a specific string in another string, reading left to right. Note, the FIND function is case-sensitive. Text FIXED function Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. Text FLOOR function Rounds a number down, toward zero, to the nearest multiple of significance. Compatibility FLOOR.MATH function Rounds a number down to the nearest integer or to the nearest multiple of significance. Math and trigonometry FLOOR.PRECISE function Rounds a number down to the nearest integer or nearest multiple of significance. Math and trigonometry FORECAST function Calculates a value based on existing x and y values using linear regression. Use this function to predict linear trends. Compatibility FORECAST.LINEAR function Calculates a value based on existing x and y values using linear regression. Statistical FORMULATEXT function Returns a formula as a text string. Lookup and reference FREQUENCY function Calculates how often values occur within a range of values and then returns a vertical array of numbers. Statistical FTEST function Calculates the value from an F-test. The value shows if the variances from two data sets are not significantly different. Compatibility FV function Returns the future value of an investment based on a constant interest rate. Financial GAMMA function Calculates the GAMMA value. Statistical GAMMA.DIST function Calculates the gamma often used in queuing analysis (probability statistics) that may have a skewed distribution. Statistical GAMMADIST function Calculates the gamma often used in queuing analysis (probability statistics). Compatibility GCD function Calculates the greatest common divisor that divides all given arguments without a remainder. Math and trigonometry GEOMEAN function Calculates the geometric mean. Statistical GROWTH function Returns estimated exponential growth based on given data. Statistical HLOOKUP function Searches the top row in a data range for a value and return another value on the same column in a row you specify. Lookup and reference HOUR function Returns an integer representing the hour of an Excel time value. Date and Time HYPERLINK function Builds a link in a cell. Lookup and reference IF function Returns one value if the logical test is TRUE and another value if the logical test is FALSE. Logical IFERROR function If the value argument returns an error, the value_if_error argument is used. If the value argument does NOT return an error, the IFERROR function returns the value argument. Logical IFNA function Handles #N/A errors only, it returns a specific value if the formula returns a #N/A error. Logical IFS function Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. Logical INDEX function Returns a value from a cell range, you specify which value based on a row and column number. Lookup and reference INDIRECT function Returns the cell reference based on a text string and shows the content of that cell reference. Lookup and reference