IFS EXCEL FUNCTION: THE EASIER WAY TO DO MULTIPLE CONDITIONS

This video introduces the easier way to do the IF function with multiple conditions compared to the Nested IF Statement in my previous video. It’s through the IFS function available in Excel 2019 and Office 365.

Similar to the NESTED IF STATEMENT, the first step to do the IFS function is to define our goal for the given data. Once we have the goal, we can easily fill out the IFS formula. The basic guide is indicate IF, then the logical test 1 followed by value 1, test 2 followed by value 2 and so on. Just like the Nested IF Statement, we should make sure that the formula covers all potential conditions and scenarios.

And you just learned how to use the IFS function. Practice if you need to in order to have a strong level of confidence around logical structuring.

Title: IFS Excel Function: The Easier Way to Do Multiple Conditions

#ifsexcelfunction
#easierwaytodomultipleconditions
#logicaltest
#multipleconditions