IFS function (multiple conditions) in Excel - Cell-by-Cell Formula Trace

Sample Data

This table shows student scores in column A. We want to assign grades in column B using the IFS function based on score ranges.

Cell	Value
A1	Score
A2	85
A3	72
A4	60
A5	45
A6	30
B1	Grade

Formula Trace

=IFS(A2>=80, "A", A2>=70, "B", A2>=60, "C", A2>=50, "D", TRUE, "F")

Step 1: A2>=80

Step 2: Since first condition is TRUE, IFS returns "A"

Cell Reference Map

    A       B
1 |Score | Grade
2 |  85  |  -> Formula here
3 |  72  |
4 |  60  |
5 |  45  |
6 |  30  |

The formula in B2 references cell A2 to check the score and assign a grade.

Result

    A       B
1 |Score | Grade
2 |  85  |   A
3 |  72  | 
4 |  60  | 
5 |  45  | 
6 |  30  |

The formula in B2 evaluates the score 85 and assigns grade 'A' because 85 is >= 80.

Sheet Trace Quiz - 3 Questions

What grade will be assigned if the score in A3 is 72 using the same formula?

A A

B B

C C

D F

Key Result

IFS(condition1, value1, condition2, value2, ..., TRUE, default_value) returns the value for the first TRUE condition.