Exercises / Foundations · 5 of 12
Find the temperature range
MAX returns the largest number in a range and MIN the smallest. Subtract one from the other to get the spread.
MAX(number1, [number2], …)Syntax
The largest number.
MIN(number1, [number2], …)Syntax
The smallest number.
Your taskIn E2, use MAX and MIN to work out the spread of the week: the highest temperature in B2:B8 minus the lowest.
I'll check your formula on this sheet and on changed versions of it, so it has to work in general. Stuck? Ask for a hint, one step at a time.
Answer cell
Type in a cell, or double-click it to edit
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Day | High °C | Measure | Value | ||
| 2 | Mon | 18 | Spread | |||
| 3 | Tue | 21 | ||||
| 4 | Wed | 24 | ||||
| 5 | Thu | 19 | ||||
| 6 | Fri | 16 | ||||
| 7 | Sat | 22 | ||||
| 8 | Sun | 25 | ||||
| 9 | ||||||
| 10 |