In our previous example, our ‘logical_test’ is ‘5 < 10’ if the number we were testing was ‘5’. It is the logical test by which we are seeking a TRUE or FALSE result. The first argument is fundamental to the function. As you can see, the ‘IF’ function has three arguments. The items inside the parentheses are what we refer to as arguments. Now that we have a bit of background about the ‘IF’ function, let’s look at the syntax: This is the feature that ‘IFS’ improves upon. If a given number is not less than 10, then the output of the ‘IF’ function is a FALSE result.Įxcel also allows us to combine multiple ‘IF’ functions into the same formula for a more complex needs. In this case, the ‘IF’ function is designed such that if a given number is less than 10, its output is a TRUE result. For instance, we might want to know if a number is less than 10. Both functions are logical functions which means that they return a value based on whether some logical test is TRUE or FALSE. In order to have a discussion about the ‘IFS’ function, it would be a good idea to review the basics of the ‘IF’ function. The ‘IFS’ function builds upon the ‘IF’ function in such a way that it simplifies one of the most common uses of the ‘IF’ function. One of those new functions is the ‘IFS’ function. With the release of Excel 2016, Microsoft included several new functions.
If you’d like to see more of his work, check out Spreadsheeto for more Excel tutorials.įollow along with this workbook that he created specifically for Excel Exposure! How To Use the IFS Function The following post was created by Kasper Langmann as a guest post for Excel Exposure.