Returns
the minimum value of the non-null elements of the given set of numbers.
Parameters
Parameter
|
Description
|
n1
|
A numeric value or expression.
|
n2 (optional)
|
Additional numeric values and/or expressions.
|
Note: FormCalc follows the IEEE-754
international standard when handling floating point numeric values.
For more information, see Number literals.
ExamplesThe
following expressions are examples of using the Min function:
Expression
|
Returns
|
Min(234, 15, 107)
|
15
|
Min("abc", 15, "Tony Blue")
|
15
|
Min("abc")
|
0
|
Min(Field1[*], Field2[0])
|
Evaluates the non-null occurrences of Sales_July as
well as the first occurrence ofSales_August, and
returns the lowest value.
|
Min(Max(Field1[*], Field2[0]), Field3, Field4)
|
The first expression evaluates the non-null
occurrences of Field1 as well as the first occurrence
ofField2, and returns the highest value. The final
result is the minimum of the returned value compared against the
values of Field3 and Field4.
See
also Max.
|
|
|
|