With the new release of Excel 2016, six new very interesting functions have been added in three libraries.
- Combines the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or ignore empty arguments
- This function depreciates CONCATENATE
- Better than the CONCAT function (it’s strange that Microsoft has introduced these 2 functions in the same release)
- TEXTJOIN combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined.
- If the delimiter is an empty text string, this function will effectively concatenate the ranges
- Can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.
- The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition
- The SWITCH function evaluates one expression (a logical test) against a list of values, and returns the result corresponding to the first matching value.
- This function is similar to the function SWITCH in Python, DAX, …
- If there is no match, an optional default value may be returned.
MAXIFS returns the maximum value among cells specified by a given set of conditions or criteria
MINIFS returns the minimum value among cells specified by a given set of conditions or criteria