0 of 46 lessons complete.
Module 5: Logic · Lesson 28 of 46
IF Function
Return different results based on a condition.
Step 1 of 20%
IF has three parts: a test, what to show if TRUE, and what to show if FALSE. Bearings fail above 80°C. In C2, type =IF(B2>80,"FAIL","PASS").
Target: C2
C2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Bearing | Temp (°C) | Result | |||
| 2 | B1 | 72 | ||||
| 3 | B2 | 85 | ||||
| 4 | B3 | 78 | ||||
| 5 | B4 | 91 | ||||
| 6 | B5 | 80 | ||||
| 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 $