New Functions in 2019
Excel 2019 introduced 6 new worksheet functions.
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. |
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