Microsoft Excel Functions & Formulas

Use the MAX function to determine 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.

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 refer-

ence; however, the cells must contain numbers or values that

can be converted to numbers.

4

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>.

Note: In Chapter 10 you will learn how to automatically

mark and shade the largest ...