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