NOT function in Excel - Dashboard Guide

Dashboard Mode - NOT function

Goal

Find out which tasks are not completed in a simple task list.

Sample Data

Task	Completed?
Buy groceries	TRUE
Clean house	FALSE
Pay bills	TRUE
Call mom	FALSE
Walk dog	TRUE

Dashboard Components

• KPI Card: Count of tasks not completed
  Formula: =COUNTIF(B2:B6,FALSE)
  Result: 2
• Table: List tasks not completed
  Formula in C2: =NOT(B2) copied down to C6
  Shows TRUE if task is not completed
• Filtered List: Show only tasks where NOT function is TRUE
  Use filter on column C to show TRUE rows only

Dashboard Layout

+----------------------+----------------------+
|      KPI Card        |    Filtered List     |
|  "Not Completed"=2  |  Tasks not done here |
+----------------------+----------------------+
|          Data Table (Task, Completed?, NOT)          |
+-----------------------------------------------------+

Interactivity

Apply a filter on the NOT column (column C) to show only tasks where the value is TRUE. This updates the filtered list to show only tasks not completed. The KPI card updates automatically because it counts FALSE in the Completed? column.

Self Check

If you add a filter to show only tasks where Completed? is TRUE, which components update?

• The KPI card does not change; it still shows 2 because COUNTIF(B2:B6,FALSE) counts all cells regardless of filters.
• The filtered list shows only the 3 completed tasks, where the NOT column is FALSE for all visible rows.

Key Result

Dashboard shows which tasks are not completed using the NOT function and counts them.