max()
Returns the highest of all values passed as parameters.
Syntax
max(value, value2, ...,)
- value - the first value.
- value2 - the second value.
Return type: Number , Percent , Money.
Sample usage
max(-2, 3, 4) returns 4.
Supported data types
Input type | Return type | Logic |
Number | Number | If a set of Number values is passed, the highest Number value will be returned as a Number value. |
Percent | Percent | If a set of Percent values is passed, the highest Percent value will be returned as a Percent value. |
Money | Money | If a set of Money values is passed, the highest Money value will be returned as a Money value. |
Unsupported data types | Null | Unsupported data types return Null. |
