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.
SWITCHThis 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.
MAXIFSThis function returns the largest number in a range, that meets a single or multiple criteria. More information available here.
MINIFSThis 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.