New Functions in 2016

Excel 2016 introduced 11 new worksheet functions.

CONCATReturns the text string that is a concatenation of several strings. Replaces CONCATENATE
FORECAST.ETSReturns a future value based on historical values.
FORECAST.ETS.CONFINTReturns a confidence interval for a future value.
FORECAST.ETS.SEASONALITYReturns the length of the repetitive seasonality pattern.
FORECAST.ETS.STATReturns a statistical value for a future value.
FORECAST.LINEARReturns the future y-value based on existing values.
IFSReturns the value based on multiple conditions you specify.
MAXIFSReturns the largest value in a list or array of numbers that satisfies multiple conditions.
MINIFSReturns the smallest value in a list or array of numbers that satisfies multiple conditions.
SWITCHReturns the value based on a list of matching items.
TEXTJOINReturns the text string that is a concatenation of several strings.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext