Dzwebs.Net

撰写电脑技术杂文十余年

Excel2016新函数

Admin | 2016-10-24 10:48:08 | 被阅次数 | 4773

温馨提示!

如果未能解决您的问题,请点击搜索;登陆可复制文章,点击登陆

  2016新版本的EXCEL,增加了如下的这些函数。

  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.


该杂文来自: Excel杂文

上一篇:LOG10返回数字以 10 为底的对数

下一篇:EXCEL2016 IFS函数

网站备案号:

网站备案号:滇ICP备11001339号-7

版权属性:

Copyright 2007-2021-forever Inc. all Rights Reserved.

联系方式:

Email:dzwebs@126.com QQ:83539231 访问统计