Description Returns the largest value in the specified list of numbers.
Syntax MAX ( number_list )
Argument | Description |
---|---|
number_list | A list of up to 30 numbers separated by commas. The list may contain numeric values, cell references, range references, or array constants.Text in and logical values in cell references and arrays are ignored. Text entered in the argument list will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Logical values entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE. |
Examples This function returns 500:
This function returns the largest value in the range: