Return the smallest value in a range.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
MIN(number1, [number2], …)MIN returns the lowest number in the values you supply, ignoring text and blanks. Pair with MINIFS for a conditional minimum.
=MIN(C2:C100)Result: $120
Lowest value in the range.
Yes — a 0 in the range will be returned as the minimum. Filter zeros out first if they shouldn't count.