IFS Function

Summary

The Excel IFS function checks multiple conditions and returns the result for the first condition that is TRUE. It is often easier to read than a long nested IF formula because the tests are written as a straight list of condition-and-result pairs.

IFS is useful when a value can fall into more than two categories, such as grading bands, performance tiers, status labels, or range-based messages. Instead of stacking several IF functions inside each other, you can keep the logic flatter and easier to follow.

IFS is helpful when the worksheet needs several ordered conditions instead of just one true/false split. It keeps multi-branch logic flatter and easier to read than a long chain of nested IF functions, especially in scoring, grading, and categorization rules.

Syntax

=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)

IFS is built from pairs. Each logical test is followed by the result to return when that test is TRUE. Microsoft documents support for up to 127 tests, but in practice it is still best to keep the formula readable and ordered carefully.

Arguments

• logical_test1 - [required] The first condition to evaluate.
• value_if_true1 - [required] The result to return if the first condition is TRUE.
• logical_test2, value_if_true2 ... - [optional] Additional test/result pairs.

If no test is TRUE, IFS returns #N/A. That is why many formulas end with TRUE, "Default" as a catch-all final branch.

IFS vs IF and SWITCH

These functions overlap, but each one fits a slightly different kind of problem.

If your tests depend on ranges like score bands or thresholds, IFS is often a better fit than SWITCH.

Using IFS

The most important rule with IFS is order. Because Excel returns the first TRUE branch, more specific or stricter tests usually need to come first. A score of 95 also meets the test >=80, so if that condition appears before >=90, the formula will stop too early and return the wrong category.

IFS becomes especially helpful when the formula would otherwise require several nested IF functions. A grading formula is a classic example: instead of opening and closing many parentheses, you can read the logic from left to right. That makes the formula easier to review and change later.

It is also a good habit to include a final catch-all branch when the input may fall outside your listed rules. A final pair such as TRUE,"Other" or TRUE,"F" helps keep the result controlled and prevents a surprise #N/A.

Example 1 - Assign a Grade

This is one of the most common IFS examples.

=IFS(B2>=90,"A",B2>=80,"B",B2>=70,"C",TRUE(),"F")

The formula checks the score from highest threshold to lowest. If B2 is 85, the first test fails, the second test is TRUE, and the result is "B".

Example 2 - Map Small Numeric Codes

IFS can also map fixed codes to readable labels.

=IFS(B2=1,"Low",B2=2,"Med",B2=3,"High")

This works well for short lists, especially when the codes are not sequential enough for CHOOSE or when you want to keep the mapping inside one formula.

Example 3 - Evaluate Ordered Thresholds

Threshold logic is another good fit for IFS.

=IFS(B2>100,"Error",B2>=0,"OK")

If B2 is above 100, the formula returns "Error". Otherwise, if it is still at least 0, it returns "OK". This is useful for validation ranges and simple alert rules.

Example 4 - Compare with Multiple Targets

IFS works nicely when the thresholds live in cells instead of being typed into the formula.

=IFS(B2>=G2,"Gold",B2>=H2,"Silver",TRUE(),"Bronze")

This returns "Gold", "Silver", or "Bronze" based on the current target values. Because the benchmarks are stored separately, you can change them without editing the logic itself.

Conclusion Recap

IFS is helpful when one value can belong to several possible categories. In this lesson, it handled grades, code labels, ordered thresholds, and tiered target results.

The most important habit is putting the tests in the right order. Excel stops at the first TRUE result, so the sequence of the checks matters.

• Core idea: IFS returns the result for the first TRUE condition.
• Best use: Multi-level rules such as grades, tiers, and threshold labels.
• Key habit: Put the conditions in the right order, usually from most restrictive to least restrictive.
• Catch-all option: Add a final TRUE,... branch when you want a default result.
• Readable alternative: Easier to scan than a long nested IF formula.
• Limit: Good for moderate logic lists, but very large mappings are often better stored in a lookup table.