How to Calculate Range in Excel

Finding the smallest and largest values in an extensive list of figures — as well as the range between those numbers — can be an exhausting process. However, Excel offers several functions that reduce the tedium by automatically extracting pertinent numbers.

Step

Use the MIN function to locate the lowest value in a range of cells. This function follows the format =MIN(range) with "range" being a range of cells, such as "=MIN(A1:D5)," or a series of numbers separated by commas, such as "=MIN(1,2,3,4,5)."

Finding the Minimum Value
credit: C. Taylor
Finding the Maximum Value
credit: C. Taylor

Step

Use the MAX function to find the highest value using the format =MAX(range). Replace "range" with the same range of cells or series of numbers that you entered in the MIN function. As an example, you might enter "=MAX(A1:D5)" or "=MAX(1,2,3,4,5)."

Calculating the Range
credit: C. Taylor

Step

Subtract the minimum value from the maximum value using the format =F1-E1, where F1 is the cell containing the maximum value and E1 is the cell containing the minimum value. The result is the range of value in which your data lies.