IFS function in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

This table shows student scores in column A. We want to assign letter grades in column B using the IFS function.

Cell	Value
A1	Score
A2	85
A3	72
A4	59
A5	40
B1	Grade

Formula Trace

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

Step 1: A2>=90

Step 2: 85>=90

Step 3: A2>=80

Step 4: 85>=80

Step 5: "B"

Cell Reference Map

    A      B
1 |Score |Grade
2 |  85  | --> formula here
3 |  72  |
4 |  59  |
5 |  40  |

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

Result

    A      B
1 |Score |Grade
2 |  85  |  B
3 |  72  | 
4 |  59  | 
5 |  40  |

The formula in B2 evaluates the score 85 and assigns grade B.

Sheet Trace Quiz - 3 Questions

What grade will the formula assign if the score is 72?

A B

B C

C D

D F

Key Result

IFS checks conditions in order and returns the value for the first true condition.