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