Use the MAX function to determine the largest value in a range - Basic Statistical Functions - Microsoft Excel Tutorials

Use the MAX function to determine the largest value in a range using Microsoft Excel

This example finds the largest value in the range A3:D11 by using the MAX function. The function’s return value is the largest (Maximum) value in a set.

MAX(number1, number2, ...)

number1, number2, ...: From 1 to 30 numbers for which you want to find the largest value. It is possible to use a cell reference; however, the cells must contain numbers or values that can be converted to numbers.

To determine the largest value:

1. In cells A3:D11 type any values.
2. In cell B1 type the formula =MAX(A3:D11).
3. Press <-Enter->.

Use the MAX function to determine the largest value in a range

Note: Later you will learn how to automatically mark and shade the largest value in a range.