|
Returns
the minimum value of the non-null elements of the given set of numbers.
Syntax
Min(
n1
[,
n2
...])
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
.
Examples
The
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 of
Sales_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
of
Field2
, 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
.
|
|
|
|
