MIN

MIN(number1,number2,...)

Number1, number2, ...     are 1 to 30 numbers for which you want to find the minimum value.

 
1
2
3
4
5
6
A
Data
10
7
9
27
2
FormulaDescription (Result)
=MIN(A2:A6)Smallest of the numbers above (2)
=MIN(A2:A6,0)Smallest of the numbers above and 0 (0)
Did this article help you? Yes No Not what I was looking for Applies to: Excel 2003