Beginner
Statistical
MIN
Returns the smallest value in a set of numbers.
Compatibility: All Excel versions
Syntax
=MIN(number1, [number2], ...)
Example
=MIN(A1:A20)
When to Use It
Use MIN to find the lowest value in a range — the smallest expense, the lowest score, the earliest date.