New Functions in 2019

Excel 2019 introduced 6 new worksheet functions.

CONCATReturns the text string that is a concatenation of several strings. Replaces CONCATENATE
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