怎样获得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.
