According to this Office article, there are 477 functions in Excel 2016. They are distributed this way:

Category | Amount |
---|---|

Statistical | 112 |

Math and trigonometry | 80 |

Financial | 55 |

Engineering | 54 |

Compatibility | 38 |

Text | 33 |

Date and time | 25 |

Lookup and reference | 24 |

Information | 20 |

Database | 12 |

Logical | 11 |

Cube | 7 |

Web | 3 |

Add-in and Automation | 3 |

Total |
477 |

The new Excel 2016 functions are shown below:

Function name | Category | Description |
---|---|---|

IFS | Logical | Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. |

SWITCH | Logical | Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. |

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 |

MAXIFS | Statistical | Returns the maximum value among cells specified by a given set of conditions or criteria |

MINIFS | Statistical | Returns the minimum value among cells specified by a given set of conditions or criteria. |

CONCAT | Text | Combines the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or IgnoreEmpty arguments. |

TEXTJOIN | Text | Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges. |

The functions that were renamed and moved to a different category are shown below:

Function name | Category | Description | Note |
---|---|---|---|

BETADIST | Compatibility | Returns the beta cumulative distribution function | In Excel 2007, this is a Statistical function. |

BETAINV | Compatibility | Returns the inverse of the cumulative distribution function for a specified beta distribution | In Excel 2007, this is a Statistical function. |

BINOMDIST | Compatibility | Returns the individual term binomial distribution probability | In Excel 2007, this is a Statistical function. |

CHIDIST | Compatibility | Returns the one-tailed probability of the chi-squared distribution | In Excel 2007, this is a Statistical function. |

CHIINV | Compatibility | Returns the inverse of the one-tailed probability of the chi-squared distribution | In Excel 2007, this is a Statistical function. |

CHITEST | Compatibility | Returns the test for independence | In Excel 2007, this is a Statistical function. |

CONFIDENCE | Compatibility | Returns the confidence interval for a population mean | In Excel 2007, this is a Statistical function. |

COVAR | Compatibility | Returns covariance, the average of the products of paired deviations | In Excel 2007, this is a Statistical function. |

CRITBINOM | Compatibility | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value | In Excel 2007, this is a Statistical function. |

FDIST | Compatibility | Returns the F probability distribution | In Excel 2007, this is a Statistical function. |

FLOOR | Compatibility | Rounds a number down, toward zero | In Excel 2007 and Excel 2010, this is a Math and trigonometry function. |

FTEST | Compatibility | Returns the result of an F-test | In Excel 2007, this is a Statistical function. |

GAMMADIST | Compatibility | Returns the gamma distribution | In Excel 2007, this is a Statistical function. |

GAMMAINV | Compatibility | Returns the inverse of the gamma cumulative distribution | In Excel 2007, this is a Statistical function. |

HYPGEOMDIST | Compatibility | Returns the hypergeometric distribution | In Excel 2007, this is a Statistical function. |

MODE | Compatibility | Returns the most common value in a data set | In Excel 2007, this is a Statistical function. |

NEGBINOMDIST | Compatibility | Returns the negative binomial distribution | In Excel 2007, this is a Statistical function. |

NORM.INV | Compatibility | Returns the inverse of the normal cumulative distribution | In Excel 2007, this is a Statistical function. |

NORMDIST | Compatibility | Returns the normal cumulative distribution | In Excel 2007, this is a Statistical function. |

NORMSDIST | Compatibility | Returns the standard normal cumulative distribution | In Excel 2007, this is a Statistical function. |

NORMSINV | Compatibility | Returns the inverse of the standard normal cumulative distribution | In Excel 2007, this is a Statistical function. |

PERCENTILE | Compatibility | Returns the k-th percentile of values in a range | In Excel 2007, this is a Statistical function. |

PERCENTRANK | Compatibility | Returns the percentage rank of a value in a data set | In Excel 2007, this is a Statistical function. |

POISSON | Compatibility | Returns the Poisson distribution | In Excel 2007, this is a Statistical function. |

QUARTILE | Compatibility | Returns the quartile of a data set | In Excel 2007, this is a Statistical function. |

RANK | Compatibility | Returns the rank of a number in a list of numbers | In Excel 2007, this is a Statistical function. |

STDEVP | Compatibility | Calculates standard deviation based on the entire population | In Excel 2007, this is a Statistical function. |

TTEST | Compatibility | Returns the probability associated with a Student’s t-test | In Excel 2007, this is a Statistical function. |

VAR | Compatibility | Estimates variance based on a sample | In Excel 2007, this is a Statistical function. |

VARP | Compatibility | Calculates variance based on the entire population | In Excel 2007, this is a Statistical function. |

WEIBULL | Compatibility | Calculates variance based on the entire population, including numbers, text, and logical values | In Excel 2007, this is a Statistical function. |

ZTEST | Compatibility | Returns the one-tailed probability-value of a z-test | In Excel 2007, this is a Statistical function. |

EXPON.DIST | Statistical | Returns the exponential distribution | In Excel 2007, this is a Statistical function. |

FORECAST | Statistical | Returns a value along a linear trend | In Excel 2016, this function is replaced with FORECAST.LINEAR as part of the new Forecasting functions, but it’s still available for compatibility with earlier versions. |