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.
