How to use Excel IFS Function

3.9 min read|Last Updated: December 15th, 2023|Categories: excel|
table of content

Writing formulas in Excel help you reach the results quicker and easier. One function that can make it easy to evaluate multiple conditions is the IFS function. There is a slight difference between the IFS function and the IF statement in Excel. Here is the guide to using the Excel IFS function.

What is the difference between IF and IFS Functions?

You may be familiar with the IF conditional statement, which can only check one statement. It means it can return TRUE or FALSE. For example, we can only check if a value is higher or lower than 50. However, Excel 2016 and later versions have the IFS  function that can make it easier to check several conditions.

Using the IFS Function, you can check several conditions in one formula and get different results. For example, it is possible to check grades to see if they’re above 80, between 80 and 60, between 60 and 50, and lower than 50. Excel will check to get the first “True” condition and show its corresponding result. Let’s see the example below:

=IFS(B4<50,”Bad”, B4<60, “OK”, B4<80, “Good”, B4>=80, “Great”) 

IFS function in Excel example
Figure 1- You can check the final grades of students and see if they are doing well on their tests.
IFS function in Excel results
Figure 2- The result of the IFS function

If we wanted to get the same results using the IF statement, we would have to write an IF formula for each condition.

Please note that it is better to write the formulas from lower to higher. This helps you write the formula easily and makes the conditions look more practical and logical. Moreover, the IFS function can handle up to 127 arguments. Yet, it would be impractical to have that many conditions in one formula.