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

Back to top

Popular Pages

More Info