AND and OR functions in Google Sheets - Dashboard Guide

Dashboard Mode - AND and OR functions

Goal

Check if students passed both Math and English, or at least one subject, using AND and OR functions.

Sample Data

Student	Math Score	English Score
Alice	85	78
Bob	55	65
Charlie	90	45
Diana	40	30
Eva	70	88

Dashboard Components

• KPI Card 1: Passed Both Subjects?
  Formula in D2: =AND(B2>=60, C2>=60)
  Shows TRUE if student scored 60 or more in both Math and English, else FALSE.
• KPI Card 2: Passed At Least One Subject?
  Formula in E2: =OR(B2>=60, C2>=60)
  Shows TRUE if student scored 60 or more in Math or English, else FALSE.
• Summary Table: Counts of students passing both or at least one subject.
  Formula for count passing both (G2): =COUNTIF(D2:D6, TRUE)
  Formula for count passing at least one (G3): =COUNTIF(E2:E6, TRUE)

Dashboard Layout

+----------------------+-------------------------+
| Passed Both Subjects? | Passed At Least One Subj |
|      (KPI Card 1)     |       (KPI Card 2)       |
+----------------------+-------------------------+
|          Summary Table (Counts)               |
+-----------------------------------------------+
|                 Sample Data                    |
+-----------------------------------------------+

Interactivity

Add a filter to select students by name. When you pick a student, the KPI cards and summary table update to show results only for that student.

Self Check

If you filter to show only students with Math Score >= 60, which KPI card shows TRUE for all visible students?

Key Result

Dashboard shows which students passed both or at least one subject using AND and OR functions.