# 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

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:

The range in this example is 60.