MIN

Returns the smallest from the specified arguments.

Syntax

MIN( Number n1, [Number n2], ... ) → Number

Parameters

n1
n2
…

One or more numbers for which to find the minimum value.

Remarks

The arguments can be either numbers, or cells or arrays that contain numbers. Logical values, text, and empty cells are ignored. To consider logical values and text, use the MINA function.

Example

Formula

=MIN(A1:A5)
=MIN(A1:A5,25)

See Also

Function Reference
MINA Function
MAX Function
MAXA Function