Uncomplicate Your Nested IF Statements with the New IFS Function


If you’ve ever had to write a nested IF function in Excel, you know how complicated they can get. You might get to the end, nervously hit Enter, and see that the whole thing has failed because you forgot a few parentheses, or you missed a comma. Well, if you have Office 365 or Office 2019, you now have access to a ridiculously easy way to create nested IF statements. It’s called the IFS function. 

Excel doesn’t often debut new functions, but boy is this one a gamechanger. Just liked a nested IF, it tests if various conditions are true, and then returns a value accordingly. Here’s the syntax of the IFS function:

=IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)

You can test up to 127 conditions. That’s right, 127! But it’s always best practice not to have too many conditions, as it can be difficult to test and modify something that long. But hey, if you are so inclined, go for it.

The easiest way to learn how to use IFS function? Watch our video and see it in action:

You can find many more videos on the new features of Office 365 and Office 2019 at www.intellezy.com.

By Heather Walsh

Flash Fill Keyboard Shortcut

Flash Fill Keyboard Shortcut 

Flash Fill is one of the most popular new features in Excel 2013/2016. It will fill in cells for you automatically based on a pattern. So if you have first names in column A, and last names in column B, you can quickly fill column C with first and last names, or last names and then first names with a comma in between. Just supply the pattern for Excel, and it will do the rest. 

And there is a handy shortcut key for Flash Fill. Simply highlight the cells containing the pattern as well as the empty cells you would like filled, and then press Ctrl + E. It’s that easy! Excel will fill in the cells with Flash Fill. 

 To learn even more about Flash Fill and see it in action, click here: 

 You can find thousands more short-segment videos like this one at www.intellezy.com. Start your free trial today.