Calculate the Range in Excel
You want to calculate the range in Excel.
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
MAX functions. In Excel we have
- The max in cell D1 is
- The min in cell D2 is
- The range in cell D3 is
The range in this example is 60.