怎样获得excel 2016新增函数

发布网友

我来回答

1个回答

热心网友

EXCEL2016新增函数有:

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

SWITCH
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.CONFINT
Returns a confidence interval for the forecast value at the specified target date

FORECAST.ETS
Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm

FORECAST.LINEAR
Returns a future value based on existing values

FORECAST.ETS.STAT
Returns a statistical value as a result of time series forecasting

FORECAST.ETS.SEASONALITY
Returns the length of the repetitive pattern Excel detects for the specified time series

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

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

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

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

声明声明:本网页内容为用户发布,旨在传播知识,不代表本网认同其观点,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。E-MAIL:11247931@qq.com