0 of 46 lessons complete.
Module 5: Logic · Lesson 27 of 46
Comparison Operators
Compare values with >, <, >=, <=, and <>.
Step 1 of 20%
The operators are: > greater than, < less than, >= greater than or equal, <= less than or equal, <> not equal. In D2, check whether T1's pressure is less than or equal to its limit.
Target: D2
A1
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Tank | Pressure (psi) | Limit (psi) | Within limit? | Over limit? | |
| 2 | T1 | 95 | 100 | |||
| 3 | T2 | 105 | 100 | |||
| 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 $