badbath.blogg.se - Excel download for windows 10 64 bit

SWITCH: This function evaluates the expression against an ordered list of values and returns the first match. If there is no match, the result will be “else”.

MINIFS: This function is similar to MAXIFS, but it returns the smallest number in a range of numbers that meets one or more criteria.

MAXIFS: This function returns the largest number in an array of numbers, which meets one or more criteria.

IFS: Tired of complicated, overlapping IF functions? The IFS function will take care of that. With this function, the test conditions will be in the order you choose. If all is well, the result will be returned. You can also select “catch-all” if there are no matching conditions.

CONCAT: This new feature is like CONCATENATE but better. Conspicuous, its name is shorter and easier to type. In addition, it also supports a range of references in addition to cell references.

What’s New in Microsoft Excel 2019 New function