Logical Functions
Beginner
Logical Comparisons
Use logical comparison formulas to produce TRUE or FALSE results.
Task:
Enter a formula in column B that returns TRUE if the value in column A is positive, otherwise FALSE.
Learning Objectives:
- Understand TRUE and FALSE constants
- Learn to write logical comparison formulas
- Practice basic boolean logic
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 | |
|---|---|---|
| 1 | Value | Is Positive |
| 2 | 8 | |
| 3 | -3 | |
| 4 | 12 | |
| 5 | -7 |
What this exercise teaches (contains the answer)
Logical comparisons in Excel (like =A2>0) return TRUE or FALSE. These are fundamental for data validation and conditional logic.