Logical Functions
Intermediate
NOT Function
Use NOT function to reverse logical values.
Task:
You are filtering a product list to exclude items in the Electronics category. Identify products that are NOT in the Electronics category in column C.
Learning Objectives:
- Learn the NOT function
- Understand logical negation
- Practice reverse logic operations
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Product | Category | Not Electronics |
| 2 | Laptop | Electronics | |
| 3 | Chair | Furniture | |
| 4 | Phone | Electronics | |
| 5 | Desk | Furniture | |
| 6 | Tablet | Electronics |
What this exercise teaches (contains the answer)
The NOT function reverses logical values, useful for finding opposite conditions or excluding specific criteria.