New Fascinating Features in Excel 2016 (January 2016 Updates)

Few weeks, I received one update for my Office 2016 (Office 365 subscription). I learnt that there are couple of new fascinating and long-awaited features in Excel 2016. I have been requesting these new functions for years, but at last…. YES!
I am very keen to use the following new functions in my excel, but you need Office 2016 (Office 365 subscription) or Office Online to open it.

IFS

Tired of typing complicated, nested IF functions? The IFS function is the solution. With this function, conditions are tested in the order that you specify. If passed, the result is returned. You can also specify an else “catch all” if none of the conditions are met.Learn about IFS here.

SWITCH

This function evaluates an expression against a list of values in order, and returns the first matching result. If no results match, the “else” is returned. Details and examples are spelled out here.

MAXIFS

This function returns the largest number in a range, that meets a single or multiple criteria. More information available here.

MINIFS

This function is similar to MAXIFS, but it returns the smallest number in a range, that meets a single or multiple criteria. Read more about the MINIFS function.

https://lcchong.wordpress.com/2016/06/28/new-fascinating-features-in-excel-2016-january-2016-updates/