Using IFS Functions

The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.

Simple syntax

Generally, the syntax for the IFS function is:
=IFS(logical_test1, value_if_true1, logical_test2, value_if_true2, …)

Example: Grading System

We want:

90 or above → A

80–89 → B

70–79 → C

Below 70 → F

Steps:

1. Select the cell you want to create an IFS function from.

IRS Function

2. Type the formula: =IFS(A1>=90,"A", A1>=80,"B", A1>=70,"C", A1<70,"F")

Formula

3. Press Enter -

If A1 is 92 → Excel shows A.

Results

4. Copy the formula down
Drag the fill handle from B2 down to match all scores.

Copy Formula Down