IFS

New Excel function in Excel 2016

The IFS function works in the same way as the existing IF function. It is the same as multiple embedded IF functions .

Syntax

IFS(logical_test1,value1, [logical_test2,value2],…)

The logical_test1 is a logical test that returns a boolean. If the test returns TRUE then the matching value1 is returned.

Each test is tried in order. After a test returns TRUE, no further tests are evaluated.

Comments

If a test does not return a boolean value, then #VALUE will be returned.

Best to use

• Simplify formulas using nested IF functions.

Limitations

The function can perform up to 127 tests.

Tip

The last test should be set to TRUE so that a value is returned instead #N/A.

If there are more than seven logical tests, consider creating a data table and using a VLOOKUP function instead.

Examples