what are the new functions in excel 2016

Each test has to return either TRUE or FALSE.

If none of the tests return True you’ll get a #N/A! error so a default is a good idea. This sets a default ‘True’ if none of the previous tests are triggered. The first condition that evaluates as True will be used and the rest of the function ignored.

IFS is a series of paired parameters … first a test, then the result or action to take if that condition is true.

It tests a student’s % grade and returns a phrase equivalent. Here’s a straightforward example that any teacher will recognize. It lets you create a series of conditions and act upon the first condition that’s true. You can almost hear the sigh of relief from Excel users as they discover IFS(). Over time, Microsoft has added functions to replace ‘IF with IF’, most notably VLOOKLUP and HLOOKUP.Įxcel 2016 for Windows gets some more functions that should work better and be easier to understand/debug. Nested IF statements have been a necessary evil for as long as there’s been worksheets. Only the Windows 10 and Android apps at the time of writing, presumably Excel for iOS will catch up soon. The new Funnel chart option is for situations where there’s a dropping (or growing) set of values from the stages of a process.įunnel charts will appear in the Recommended Chart list or choose from the new ‘Funnel’ option for all chart choices.įunnel charts are also available in Excel Mobile. That includes the ones Microsoft isn’t talking about! Funnel charts

Like to know more? Office 2016: the real startup guide has already been updated with comprehensive coverage of all the new features. Check out separate articles on the specific new features in Excel, PowerPoint and Outlook.

We have extensive coverage of the overall changes that apply to Word, Excel and PowerPoint. Many useful changes in Excel 2016 for Windows in the January 2016 update.

What are the new functions in excel 2016