Excel Function

IFS

Evaluates multiple conditions in order.

IFS(logical_test1, value_if_true1, ...)

Arguments

logical_test1

Required

Enter an expression such as comparison or calculation.

value_if_true1

Required

Enter a text value (wrap with quotes when needed).

logical_test2

Optional

Enter an expression such as comparison or calculation.

value_if_true2

Optional

Enter a text value (wrap with quotes when needed).

Practice Preview

Use IFS to return "A" when cell C2 (Score in column C) is greater than or equal to 90; otherwise return "B" when cell C2 (Score in column C) is greater than or equal to 80.

Example Table

#	ALearner ID	BName	CScore
2	U001	Tanaka	82
3	U002	Sato	67
4	U003	Suzuki	91
5	U004	Takahashi	55
6	U005	Ito	78
7
8

How to Use (Formula)

=IFS(C2>=90, "A", C2>=80, "B")

Result

Practice This Function

Start Function Practice Back to Function List

IFS FAQ

How do I use IFS in Excel?

Use IFS when you want to return different results across multiple conditions. Enter Logical test 1, Value if true 1, Logical test 2 in that order, then add optional arguments when needed.

Where can I practice IFS?

Use the "Start Function Practice" button to jump straight into IFS drills.

What arguments does IFS use?

The main arguments are Logical test 1, Value if true 1, Logical test 2, Value if true 2. Start with the required ones, then add optional arguments if needed.