Min

Calculates the (numerical) minimum out of all of the values in a list of values, ranges and/or lists.

Syntax

Min(param1, param2, ...)
param1 = first parameter in the value set (value, range, or list)
param2 = second parameter in the value set (value, range, or list)
... = nth parameter in the value set (value, range, or list)

Remarks

This function accepts an unlimited number of parameters.
Any non-numerical values are ignored.

See also Max

Examples

Min(1, 2) = 1
Min(A1:B3) = the minimum of all of the numerical values in the A1:B3 range

Classification

Maths Ranges Statistics