Overview

This finds the smallest and largest of your numbers, along with the range between them. The range is a quick first measure of how spread out data are.

Enter your values in any order. Negative numbers and decimals are fine.

Worked examples

InputsResult
Your numbers12, 16, 14, 21, 19Min: 12Max: 21Range: 9
Show 2 more examples
Your numbers-8, -2, 3, 0, 7Min: -8Max: 7Range: 15
Your numbers2.5, 2.05, 2.55, 2.505, 2Min: 2Max: 2.55Range: 0.55

How it works

Each value is compared to find the lowest and highest. The range is the maximum minus the minimum. Because the range depends on only two values, one unusual data point can change it a lot.

The formula

Range = maximum − minimum

Practical tips

  • For 12, 16, 14, 21 and 19, the minimum is 12, the maximum is 21 and the range is 9.
  • With negatives, the minimum is the furthest below zero. The minimum of −8, −2 and 3 is −8.
  • Check extreme values before relying on them, since a typing error often appears as a surprising max or min.

Frequently asked questions

What's the range used for?

It's a quick view of spread. For more detail, use the interquartile range or standard deviation.

Can minimum and maximum be the same?

Yes, if all the values are equal, and the range is then 0.

How do I find max and min in Excel?

Use =MIN(A1:A5) and =MAX(A1:A5).