Four brackets measure 8.2, 7.9, 8.6 and 8.3 mm. The range tells you how far apart the extremes are, in millimeters.

Calculate the distance between the endpoints

Put the four numeric readings in B2:B5. Use:

=MAX(B2:B5)-MIN(B2:B5)

MAX returns 8.6 and MIN returns 7.9, so the range is 0.7 mm. Keep the unit beside the result rather than typing it into each numeric cell.

Four bracket readings are 8.2, 7.9, 8.6 and 8.3 mm, with the lowest and highest marked.

Illustrated data. Use a single measurement unit for the set.

Verify the extremes and the count

Use =COUNT(B2:B5) to check that all four expected readings are numeric. Inspect an unusually high or low reading against the source before drawing a conclusion. A missing value or a number stored as text can hide a true endpoint.

A number line shows the distance from 7.9 to 8.6 mm as 0.7 mm.

Illustrated spread. Check both endpoints before interpreting the result.

A range of zero can mean every reading is the same, or that only one numeric reading is present. Include the count when showing the spread.

Microsoft’s MAX, MIN and COUNT reference.