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

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.