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.
Video of the Day
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)."
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)."
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.