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.

xoffice-apps-pagespeed-ic-w84pq4w2tq

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s