IFS Function in Excel

Hello all. In this tutorial, let’s look at one of the new functions that’s available in Excel 2019 and 365 versions – IFS. IFS function is used to test multiple conditions and returns the first TRUE result. Unlike the IF function, IFS allows to test multiple conditions without nesting. Let’s look at the syntax and jump into couple of examples.

Syntax: =IFS(test1, value1, [test2, value2],…)
In the below example, compensation band of the employee has to be mapped based on their yearly salary. Categories available are A,B,C. For salary less than 7000, the category is C. If Salary >7000 but <10000, then category is B. If salary >10000 but <15000 then category is A. 
Instead of having multiple nesting of IF functions, IFS gives a straight forward solution. If checks each condition one by one and returns the value of the first TRUE condition.
Here, first the function checks if the D3 value is < 7000. If yes, it would return “C”. If no, goes and checks if its < 10000. If yes, return “B”.. and so on.
Other pointers about IFS function
  • All the logical tests must either return a TRUE or FALSE value. Else the function would return “#value!” error
  • If none of the test yields a true value, then the function would return “#NA” error.     

I hope you like this guide on IFS function. Please provide us with your valuable feedback that would help in improving the content. Thanks for reading. 

One thought on “IFS Function in Excel

Leave a Reply

%d bloggers like this: