How to Calculate a Range in Excel

Excel Tip of the Day:

The range provides information on the statistical dispersion of a data sample. Simply subtract the lowest number from the highest number, and it is easy to calculate the range in Microsoft Excel.

1. In a new workbook, type the list of numbers in a column.
2. To find the highest number in the data sample: Click on a blank cell and type =Max(range of cells), where range of cells is the first and cell that contain data points. Ex: data in cells A1 to A100, the range is A1:A100.
3. To find the lowest number in the data sample: Click on another blank cell and type =Min(range of cells), with the same range of numbers from step 2.
4. Click on another blank cell and type =, followed by the cell that contains the maximum value, -, the cell that contains the lowest value. Ex: If cell A101 contains the maximum value and cell A102 contains the minimum value, type =A102-A101 in cell A103 to find the range.

Work faster and more efficiently in Excel:

Join us at DeVore Technologies in Beachwood, OH!

• Excel 2007 Introduction- 2/13
• Excel 2007 Intermediate – 2/20
• Excel 2010 Intermediate – 2/21
• Take a look at our complete course offerings!

Please don’t hesitate to contact our training team
with questions or to register 440.232.3846

Advertisement