Office 2016 Excel component adds 6 new functions to simplify formula editing

The importance of Microsoft Office productivity tools is slowly being replaced by Azure, but as one of Microsoft's most important revenue products, Office software every move is very compelling. After all, as a tool to drive the world forward, we need to be well aware of its dynamic. Now, Office 2016 in the Excel component has ushered in the update, added six new functions, the purpose is to simplify the editing of the formula for data statistics to bring a more humane experience. The following is updated details: TEXTJOIN and CONCAT functions These two commands help simplify the daily task of merging text strings. When you merge two or more units in Excel, you will need a separator or a comma to separate each item: E.g: Traditional way: = CONCATENATE (A3, ",", B3, ",", C3, ",", D3, ",", E3)

The new process eliminates the need to use commas or quotation marks for the separation operation, simplifying the operation in Excel. E.g: Use TEXTJOIN to merge text strings with new methods: = TEXTJOIN (",", TRUE, A3: E3)

IFS and SWITCH functions free office 2016 product key download online Normally, if you want to get the results from a test, you will generally choose to use the IF function. The new command is implemented by nesting the IF function (IF (IF ())). But it's time-consuming and laborious. So the Office team created a new IFS function. An example of applying a new function is to assign a rating to a test based on the value of each score. For example: If the value in C1 is greater than or equal to 90, then it belongs to A. Otherwise, if it is less than 90 and greater than or equal to 80, then it is B. So on and so forth.

The new IFS function simplifies the formula by allowing the user to specify the state in a single function. For the SWITCH function, this function allows multiple states to be entered by specifying a result or a numeric expression or sequence. The value is compared to this expression, and when a match is generated, a result is generated. For example: Get the size value from the item in column B. If it is "XS", the result is "Extra Small", otherwise, if it is "S", the result is "Small". So on and so forth. If there is no match, the result is "Not Specified". In the above IF function, if you use nested way instead of the new IFS function, the expression will be very complicated. MAXIFS and MINIFS functions

These two functions can help to calculate the maximum or minimum in a certain range. The new functionality of these new functions allows the user to create a state within the above range before calculating the maximum or minimum value. For example: MINIFS and MAXIFS are used to calculate the minimum and maximum sales data in the table. However, if the value in the Retailer section is "BigMart", the value in the Brand column is "Longlast" and the value in the Sales section is greater than 0, which will only contain values ​​from the Sales section.