If you’re familiar with using the IF function in Excel, then you might be ready to check out the IFS function. With it, you can test multiple conditions at once, instead of using nested IF statements.
Using IFS, you can test up to 127 conditions in a single Excel formula. Although this number of tests is probably much more than you need, the function is ideal for checking several conditions. The formula then returns the value you specify for the first true condition in the statement.
Use the IFS Function in Excel
The syntax for the function is IFS(test1, if_true1, test2, if_true2,…) where you enter the condition for each test argument and the value to return if the test is true for each true argument.
Let’s look at a few basic examples.
Return Cell Reference Values
Here, the condition looks at the ID number in cell C2. When the formula finds the matching condition, 1 through 5, it returns the corresponding name.
=IFS(C2=1,A2,C2=2,A3,C2=3,A4,C2=4,A5,C2=5,A6)
To break down the formula, if the value in cell C2 is 1, return the value in A2, if it’s 2, return…
Read Full Article Source
