Buzz
This article introduces you to the MIN function - one of the most popular statistical functions in Excel.
Description: Returns the smallest value among the given numbers.
Syntax: MIN(number1, [number2], ...)
In which:
- number1, [number2], ...) are the values you want to find the median of, where number1 is the required parameter, and others are optional with a maximum of 255 number parameters.
Note:
- The arguments must be numbers, names, arrays, or references containing numbers.
- Logical or text values directly entered into the argument list -> these values are still considered.
- If the argument is a reference array containing text or logical values -> these values are ignored, though 0 is still counted.
- If the arguments do not contain numbers -> the function returns 0.
- Text or error values that cannot be converted as arguments -> cause an error for the function.
- If you want to calculate both text and logical values -> use the MINA function.
Example:
Calculate the smallest value of the numbers described in the data table below:
- Calculate the smallest value among the numbers. In the cell where you want to calculate, enter the formula: =MIN(D6:D11)
- Press Enter -> the smallest value is:
- Calculate the smallest value among the numbers and 25 -> enter the formula: =MIN(D6:D11,25) -> press Enter -> the smallest value is:
- If all values are text or logical -> the function returns 0 and ignores those values:
Here's the guide and some specific examples of using the MIN function in Excel.
Wishing you all success!
