Chart for .NET / User's Guide / Data Manipulation / Functions / Statistical Functions / Min

Min
 Syntax
MIN(arg1 [; ByEveryN])
 Arguments
The 'arg1' argument must be an array.
ByEveryN is an optional argument - an integer constant, greater or equal to 1.
 Result
Returns a scalar value, which is the minimum value of the elements in the array 'arg1'.
If ByEveryN is supplied, then the function calculates the minimum for each group of N successive elements and the result is an array.
 Description

Calculates the min value of all the elements in the input array, or the min value of every N successive elements in the input array.

Example 1:

Expression: MIN( arg1 )

arg1 11 7 3 5 6 1

Result: 1

Example 2:

(min by every 2 elements)

Expression: MIN( arg1; 2 )

arg1 11 7 3 5 6 1
result 7 3 1
 Related Examples
Windows Forms: All Examples\Data Manipulation\Functions\Statistical\Average, Median, Min, Max