MIN Function in Excel
Table of Content:
MIN Function in Excel
The MIN function in Excel is a mathematical function that allows you to find the minimum value in a range of cells.
The syntax of the MIN function is as follows:
MIN(number1, [number2], ...)
where:
- "number1" is the first number or range of cells from which you want to find the minimum value.
- "[number2]" is an optional argument that represents additional numbers or ranges of cells from which you want to find the minimum value.
For example, if you have a range of cells containing some numbers, say A1:A5, and you want to find the minimum value in that range, you can use the following formula:
=MIN(A1:A5)
The result will be the smallest value in the range A1:A5.
The MIN function can be very useful when you need to find the smallest or minimum value in a range of data, such as finding the lowest sales figure for a particular product or the lowest score on a test.