Min function will be used to search for the smallest value in a data range, maybe a whole worksheet or only a certain range of data. How to use the Min function in Excel is guided in the following article.
Syntax: =MIN(number1, [number2], …)
The MIN function syntax has the following arguments:
- number1 – the first number from a set of values from which you want to get the minimum value.
- [number2], .. – (optional) second number from a set of values from which you want to get the minimum value. Up to 255 arguments can be used in the MIN function.
MIN in Excel Example:
1.1 For example, to get the smallest value in the range C17:C24, use this simple formula:
Syntax: =MIN(C17:C24)
Result:
1.2 For example, to get the smallest value in the range D18,D20,D22,D24, use this simple formula:
Syntax: =MIN(D18,D20,D22,D24)
Result:
1.3 For example, to get the smallest value in the range C17:E24, use this simple formula:
Syntax: =MIN(C17:E24)
Result: