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. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext