Function Description
| Category | Description |
|---|---|
| Syntax | MAX(number1,number2,...) |
| Function | Returns the maximum value in the parameter list. |
| Parameter | number1, number2, ...: 1 to n values from which the maximum value needs to be found |
| Number of Parameters | Unlimited |
| Parameter Types | Numbers, logical values, and text expressions of numbers |
| Return Value Type | Number |
| Notes | If parameter values include unsupported types, MAX returns the #VALUE! error. |
Examples
| Formula | Result |
|---|---|
MAX(0.1,0,1.2) | 1.2 |
MAX(true,false) | 1 |
MAX(true,1+2) | 3 |