Description:
Compute the maximum value of all the non-null members in a sequence.
Syntax:
A.max() |
Equivalent to max(x1,…,xn) |
Note:
The function computes the maximum value of all the non-null members in sequence A. Note that this function doesn’t apply to a sequence whose members are not of the same data type.
Parameters:
A |
A sequence |
Return value:
The maximum value of all members in sequence A
Example:
|
A |
|
1 |
=[8,-6,1,3,5].max() |
8 |
2 |
=["c","b","e","A"].max() |
"e" |
3 |
=["a",1].max() |
Error message is displayed because the members are of different data types |
4 |
=["a",null,"b"].max() |
"b" |
5 |
=max(8,-6,1,3,5) |
8 |
Related functions: