Calculate the Range in Excel

Your goal

You want to calculate the range in Excel.

Step-by-step tutorial

Consider the following dataset:

83, 87, 61, 92, 38, 78, 73, 55, 98, 74, 86, 69, 40, 83

Excel doesn't have a range function, so we need to calculate the range using the MIN and MAX functions. In Excel we have

Calculating the range
Calculating the range

where

  • The max in cell D1 is =MAX(A1:A14)
  • The min in cell D2 is =MIN(A1:A14)
  • The range in cell D3 is =D2-D1

For example:

Calculating the min
Calculating the min

The range in this example is 60.