@Min (Formula Language)
Returns the smallest number in a single list, or the smaller of two numbers or number lists.
Note: The single-parameter form of this @function
is new with Release 6.
Syntax
@Min( number1 )
@Min( number1 ; number2 )
Parameters
number1
Number or number list.
number2
Number or number list.
Return value
minNumber
(Single parameter) Number. The smallest number in number1.
(Two parameters) Number or number list. Either number1 or number2, whichever is smaller. If the parameters are number lists, @Max returns a list that is the result of pair-wise computation on the list values.
Usage
When using this function with a number list constant, remember that the list concatenation operator takes precedence over other operators. Enclose negative numbers in parentheses.
Examples
- This example returns 35.
@Min(35;100) - This example returns 5;2;3;3.
@Min(99:2:3;5:6:7:8) - This example returns the contents of the field containing the
smallest value. If Precinct1 contains 150,000 and Precinct2 contains
100,000, then this formula returns 100,000.
@Min(Precinct1;Precinct2) - This example returns 85,000 if 100,000 is the smallest number
contained in either of the fields AreaAPopulation or AreaBPopulation,
and the field DistrictPopulation contains the value 15,000.
@Min(AreaAPopulation;AreaBPopulation) - DistrictPopulation - This example returns -3.5;-35;54.
@Min((-3.5):(-35):100;(-2):45:54) - This example returns 2.
@Min(99 : 2 : 3)