Quick, clean, and to the point

Excel IFS Function

Excel IFS function

The Excel IFS function runs multiple tests and returns a value corresponding to the first TRUE result. Use the IFS function to evaluate multiple conditions without multiple nested IF statements. IFS allows shorter, easier to read formulas.

Test multiple conditions, return first true
Return value 
Value corresponding with first TRUE result
=IFS (test1, value1, [test2, value2], ...)
  • test1 - First logical test.
  • value1 - Result when test1 is TRUE.
  • test2, value2 - [optional] Second test/value pair.
Usage notes 

IFS is a new function, available in Office 365 and Excel 2019.

Use the IFS function to test multiple conditions and return a value corresponding to the first TRUE result. Unlike the IF function, IFS allows you to test more than one condition without nesting. This makes makes formulas with many conditions easier to read.

Arguments are entered in test/value pairs. Each test (condition) represents a logical test that returns TRUE or FALSE, and each value is associated with the previous test. A value is returned by IFS only when its test returns TRUE, and the first test with a TRUE result "wins". The IFS function supports up to 127 conditions.

Example #1

In the example shown, the formula in E5, copied down, is:


Example #2

To assign "Poor" to scores below 50, "Average" to scores between 50 and 75, and "Good" to scores over 75, you can configure IFS like this:



  1. There is no way to set a default if all tests return FALSE (i.e. a value if false). Instead, enter TRUE for the last test, and then a value to return as a default value if FALSE.
  2. All logical tests must return TRUE or FALSE. Other results will case IFS to return a #VALUE! error.
  3. If no logical tests return TRUE, IFS returns the #N/A error.