Excel MAX Function
A D V E R T I S E M E N T
The Excel MAX function is used to find the largest value in the selected
range of cells or a given list of arguments. Text and blank entries are not
included in the calculations of the MAX function.
The syntax for the
MAX function is:
=MAX(Argument1, Argument2, ... Argument30)
Argument1, Argument2, ... Argument30 can be numbers, named ranges, arrays, or
cell references. Up to 30 arguments can be entered in Excel 2003.
To use the MAX function (an example)
Enter the following data into cells C1 to C5:
Click on cell C7 where the results will be displayed.
Type =MAX(C1:C5) in cell C7.
Once finish, press the Enter key on the keyboard.
The answer 953.5 appears in cell C7 which is the largest number in the list.