IFS function in Google Sheets - Dashboard Guide

Dashboard Mode - IFS function

Goal

We want to quickly assign a grade to each student based on their score using multiple conditions.

Sample Data

Student	Score
Alice	92
Bob	85
Charlie	73
Diana	67
Edward	58
Fiona	45

Dashboard Components

• Grades Column: Next to the scores, we add a column called "Grade". We use the IFS function to assign grades based on score ranges.
• Formula for Grade (in cell C2): =IFS(B2>=90, "A", B2>=80, "B", B2>=70, "C", B2>=60, "D", B2<60, "F")
• Explanation: This formula checks each condition in order. If the score is 90 or above, it returns "A". If not, it checks if 80 or above for "B", and so on.
• Result: For Alice (92), grade is "A"; for Bob (85), grade is "B"; for Charlie (73), grade is "C"; for Diana (67), grade is "D"; for Edward (58), grade is "F"; for Fiona (45), grade is "F".

Dashboard Layout

+-----------------------------+
| Student | Score | Grade     |
|---------|-------|-----------|
| Alice   | 92    | A         |
| Bob     | 85    | B         |
| Charlie | 73    | C         |
| Diana   | 67    | D         |
| Edward  | 58    | F         |
| Fiona   | 45    | F         |
+-----------------------------+

Interactivity

You can change any student's score in the Score column. The Grade column will automatically update because the IFS formula recalculates the grade based on the new score.

For example, if you change Diana's score from 67 to 82, the grade will update from "D" to "B" immediately.

Self Check

Try changing Edward's score to 75. What grade does he get now? (Answer: "C")

Try changing Fiona's score to 60. What grade does she get now? (Answer: "D")

Key Result

Assigns letter grades to students based on their scores using the IFS function.