Map charts : You can create cartographic charts to compare values and show categories across geographies. Use it when you have geographic areas in your data, such as country/region, state, county, zip code, etc.TEXTJOIN : This function combines content from multiple ranges, and each item is split by the delimiter you choose.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
0 kommentar(er)
