New Functions in 2019

Excel 2019 introduced 6 new worksheet functions.
You may see these function in Excel 2016 if you have the latest updates installed.

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 exact matches.
TEXTJOINReturns the text string that is a concatenation of several strings.
CONCAT
Returns the text string that is a concatenation of several strings. Replaces CONCATENATE
IFS
Returns the value based on multiple conditions you specify.
MAXIFS
Returns the largest value in a list or array of numbers that satisfies multiple conditions.
MINIFS
Returns the smallest value in a list or array of numbers that satisfies multiple conditions.
SWITCH
Returns the value based on a list of exact matches.
TEXTJOIN
Returns the text string that is a concatenation of several strings.

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