0 of 46 lessons complete.
Module 5: Logic · Lesson 26 of 46
TRUE & FALSE
Test whether two values are equal.
Step 1 of 20%
A formula can ask a yes-or-no question. In D2, type =B2=C2 to check whether Zone 1 is at its setpoint.
Target: D2
A1
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Zone | Setpoint (°F) | Actual (°F) | At setpoint? | ||
| 2 | Zone 1 | 72 | 72 | |||
| 3 | Zone 2 | 72 | 70 | |||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Arrow keys move · drag or shift-click to select a range · Ctrl/Cmd+D fill down · Ctrl/Cmd+R fill right · Alt+= AutoSum · F4 toggles $