0 of 46 lessons complete.
Module 5: Logic · Lesson 30 of 46
AND & OR
Check multiple conditions at once.
Step 1 of 20%
AND returns TRUE only if every condition is TRUE. A part is in spec between 9.95 and 10.05 mm. In C2, write =AND(B2>=9.95,B2<=10.05), then fill down to C6.
Target: C2:C6
C2
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Part | Diameter (mm) | In spec? | Out of spec? | Spec: 10.00 ± 0.05 mm | ||
| 2 | P1 | 10.02 | |||||
| 3 | P2 | 9.93 | |||||
| 4 | P3 | 10.05 | |||||
| 5 | P4 | 10.07 | |||||
| 6 | P5 | 9.98 | |||||
| 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 $