Map and Table Calculation

MIN( ) function

Returns the minimum value.

Syntax

MIN(ValueColumn)
MIN(Value a, Value b)
MIN(Value a, Value b, Value c)

Input

ValueColumn	is a value column
Domain type:	any Value domain
Value a	is a value
Domain type:	any Value domain
Value b	is a value
Domain type:	any Value domain
Value c	is a value
Domain type:	any Value domain

Output

MIN returns:	a real value
Domain:	system domain Value

Notes:

The MIN(ValueColumn) function, i.e. 1 parameter only, can only be used in TabCalc.
To retrieve the minimum value of a single raster map, use the function MAPMIN.
The MIN function can also be performed through a dialog box, see Column Statistics.
When one of the input parameters is undefined, or when more input parameters are undefined, the output will also be undefined.

Tip:

When the definition symbol = is used, a dependent output map or dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output map/column has been calculated.

Usable in

MapCalc, TabCalc, Simple calculators

Examples

Pocket line calculator examples:

? MIN(3.8,8.1,1.34)	returns 1.34
? MIN(PIDIV4,NEG(2))	returns -2.0000
? MIN(Column1)	returns the minimum of column1 when used on the command line of the table window

MapCalc example:

OutMap = MIN(InMapA,InMapB)

InMapA

InMapB

OutMap

8	6	-4
4	-11	0
?	-7	3

8	7	-2
14	1	2
5	?	9

8	6	-4
4	-11	0
?	?	3

TabCalc example:

OutCol1 = MIN(InColA)

OutCol2 = MIN(InColA,IncolB)
OutCol3 = IFUNDEF(InColA,MIN(IncolA))

InColA	InColB	OutCol1	OutCol2	OutCol3
8	8	-11	8	8
6	7	-11	6	6
-4	-2	-11	-4	-4
4	14	-11	4	4
-11	1	-11	-11	-11
0	2	-11	0	0
?	5	-11	?	-11
-7	?	-11	?	-7
3	9	-11	3	3

MAX	AVG	VAR	TTEST
SUM	STD	COV	CHISQUARE
CUM	STDEV	COVAR	Column Statistics
CNT	STDERR	CORR	AGGMIN