MIN
Gives the smallest number in the data specified skipping text and logical values
Gives the smallest number in the data specified skipping text and logical values
Syntax of Excel Min formula
=MIN(number1,[number2], …)
In words:
=What is the minimum (smallest)number among(this number, [this number], or this number and so on…)
=MIN(6,7,8,76,83,86) will return 6
=MIN(A1:H7) will return the smallest number in the range A1:H7