Note:MAX
Description
MAX returns the largest value in the specified list of numbers.
Syntax
MAX ( number_list )
|
Parameter |
Description |
|
number_list |
A list of as many as 30 numbers, separated by the corresponding list separator. |
|
|
The list can contain numbers, logical values, text representations of numbers, or a reference to a range containing those values. Error values or text that cannot be translated into numbers return errors. |
|
. |
If a range reference is included in the list, text, logical expressions, and empty cells in the range are ignored If there are no numbers in the list, 0 is returned. |
Examples
This function returns 500:
MAX(50, 100, 150, 500, 200)
This function returns the largest value in the range:
MAX(A1:F12)
Note:
If an Invalid formula syntax warning appears, check whether the comma is set as the list separator in your regional settings on the Windows Control Panel. If a different character is set as the list separator, use this character in the above examples in place of the comma. (Windows XP: Access the Windows Control Panel and select Regional and Language Options. On the Regional Options tab page, click Customize. On the Numbers tab page, check which character is the default list separator on your computer. Use this character in the above examples instead of the comma.
Also, see