Return the smallest value in a range.
Syntax
MIN(number1, [number2], …)Arguments
number1required
The first number or range.
number2…optional
Additional numbers or ranges.
MIN returns the lowest number in the values you supply, ignoring text and blanks. Pair with MINIFS for a conditional minimum.
=MIN(C2:C100)→$120Lowest value in the range.
Select the range
Highlight the numbers to scan.
Yes — a 0 in the range will be returned as the minimum. Filter zeros out first if they shouldn't count.