How to Use the MAX function to find the largest value in a range
This example finds the largest value in the range A3:D11 by using the MAX function. The function’s return value is the largest value in a set. Here is the syntax for using the MAX Function
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 in a range:
- In cells A3:D11 type any values.
- In cell B1 type the formula =MAX(A3:D11).
- Press Enter.
This tip is compatible with Excel 97, 2000, 2003 and 2007.
