IFS Function in Excel 2013

Home / Excel / 300 level / IFS Function in Excel 2013

You can add an IFS Function for Excel 2013, 2010, and 2007

Excel 2016 introduced a new function called IFS. You can add an IFS function to your copy of Excel 2013, 2010, or 2007 with the Excel PowerUps add-in.

The IFS function in Excel 2013 allows you to specify a series of conditions easily in a single function without having to nest several IF functions. For example:

IF(IF(IF(IF())))

Each condition of the IFS function is followed by the value to be returned if the condition is true. The value returned will be for the first condition that is true.

You can also specify a default value to be returned if none of the values matches the expression by making the last condition be always true (1=1, or true() ).

If you have ever have to fight keeping track of nested IF statements, you’ll definitely appreciate the simplicity of the IFS function.

Example of the IFS function in Excel 2013

In this example of the IFS function in Excel 2013 (or Excel 2010 or 2007)  you can see the difference between using IFS and accomplishing the same task with nested IF statements. You can imagine, as the number of options may increase, how complicated it would be to track the function nesting in Excel.

First, the IFS Function in Excel

Let’s say you want to determine the respective quartile based on a result value. In the example below, you can just imagine returning a value between 1 and 4 based on the result.

IFS function

Next, Using Nested IF Functions Instead

Here is the same function written without the IFS function. You can see how unwieldy this would become with more values to keep track of.

nested if functions