MIN function

Category: Statistical functions

What does this function do?

Returns the minimum value in a list of values. Ignores logical values and text.

Syntax:

MIN(number1,number2,...)

• number1 (required): The first of the values or ranges to evaluate.
• number2 (optional): From the second number or range parameters are optional.

Examples:

=MIN(1, 2, 3) = 1
=MIN(A1:A2,B1:B2) = 1, if A1:A2= {1,2} and B1:B2= {2,3}