Logical

IFS

Definition

IFS returns the result for the first test that is true.

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

Argument	Meaning
`logical_test1`	The first test, such as `A2>=100`.
`value_if_true1`	What to return when that first test is true. Text must sit in double quotes.
`logical_test2, value_if_true2, ...`	Optional later pairs. Excel stops at the first test that is true.

A club awards Gold at 100 points, Silver at 50, and Bronze otherwise. Points are in A2:A4.

Formula: =IFS(A2>=100,"Gold",A2>=50,"Silver",A2>=0,"Bronze")

Result: Silver. 64 is below 100 and at least 50, so the second pair returns Silver. Filled down, the formula gives Silver, Gold, and Bronze.

Cell A2 holds 80. In B2, write a formula that returns "A" when A2 is at least 90, "B" when A2 is at least 70, and "C" when A2 is at least 0.

In B2, write an IFS formula that shows A when A2 is at least 90, B when A2 is at least 70, and C when A2 is at least 0.
B2 should show the result for 80.

Step 1 of 2

Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.

Loading the sheet…

IF handles one test with two outcomes. IFS lists several tests in order and returns the first match.

Putting a wider test first, such as A2>=0 before A2>=100: every non-negative score matches the first pair, so Gold and Silver never run.