Find the fastest time with MIN
Step 1 of 3
MIN returns the smallest number in a range, and MAX the largest. The order the numbers are in doesn't matter.
Click Continue when you're ready.
Already know it? Type the formula straight into B8.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Runner | Seconds | ||||
| 2 | Ida | 12.4 | ||||
| 3 | Jon | 11.8 | ||||
| 4 | Kim | 13.1 | ||||
| 5 | Lea | 11.5 | ||||
| 6 | Mads | 12 | ||||
| 7 | Nora | 12.7 | ||||
| 8 | ||||||
| 9 |
Need help?
Why this works
MIN returns the smallest number in the range. For race times, smaller is better, so MIN finds the winner: 11.5 seconds.
Common mistake: Reaching for MAX because you want the best result. For times, the best is the lowest number.
The answer
- B8
=MIN(B2:B7)
+10 points