Excel functions are mathematical formulas that can be used to perform calculations or other actions on data in a worksheet.
Functions can be used to perform simple tasks, such as summing a column of numbers, or more complex tasks, such as calculating a mortgage payment.
Functions can be entered into a cell directly, or they can be used in conjunction with other formulas.
| FACTDOUBLE | Math and trigonometry |
 |
Returns the double factorial of a number |
| FALSE | Logical |
|
Returns the logical value FALSE |
| FDIST | Compatibility |
|
Returns the F probability distribution |
| FILTERXML | Web |
|
Returns specific data from the XML content by using the specified XPath |
| FIND – FINDB | Text |
|
Finds one text value within another (case-sensitive) |
| FINV | Statistical |
|
Returns the inverse of the F probability distribution |
| FISHER | Statistical |
|
Returns the Fisher transformation |
| FISHERINV | Statistical |
|
Returns the inverse of the Fisher transformation |
| FIXED | Text |
|
Formats a number as text with a fixed number of decimals |
| FLOOR | Compatibility |
|
Rounds a number down, toward zero |
| FLOOR.MATH | Math and trigonometry |
|
Rounds a number down, to the nearest integer or to the nearest multiple of significance |
| FLOOR.PRECISE | Math and trigonometry |
|
Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. |
| FORECAST | Statistical |
|
Returns a value along a linear trend |
| FORECAST.ETS | Statistical |
|
Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm |
| FORECAST.ETS.CONFINT | Statistical |
|
Returns a confidence interval for the forecast value at the specified target date |
| FORECAST.ETS.SEASONALITY | Statistical |
|
Returns the length of the repetitive pattern Excel detects for the specified time series |
| FORECAST.ETS.STAT | Statistical |
|
Returns a statistical value as a result of time series forecasting |
| FORECAST.LINEAR | Statistical |
|
Returns a future value based on existing values |
| FORMULATEXT | Lookup and reference |
|
Returns the formula at the given reference as text |
| FREQUENCY | Statistical |
|
Returns a frequency distribution as a vertical array |
