MIN function - The function returns the smallest value in the given numbers in Excel
The following article introduces you to MIN - 1 of the functions in the group of statistical functions that are very popular in Excel.
Description: The function returns the smallest value in the given numbers.
Syntax: MIN (number1, [number2], .)
Inside:
- number1, [number2], .) Are the values you want to find the median, where number1 is the required parameter, other values are optional and contain up to 255 number parameters .
Attention:
- The value of the argument must be a number, name, array or reference containing numbers.
- Logical or text values when typing directly into the argument list -> these values are still counted.
- If the argument is a reference array containing text values or logic -> these values are ignored, but the value 0 is still counted.
- If the arguments do not contain numbers -> the function returns the value 0.
- Arguments that are text or error values cannot be converted -> cause errors in the function.
- In case you want to calculate both text values and logic -> use MINA function .
For example:
Calculate the minimum value of the number values as described in the following data table:
- Calculate the minimum value in the number values . In the cell to calculate enter the formula : = MIN (D6: D11)
- Press Enter -> minimum value is:
- Calculate the smallest value in the numbers number and 25 -> enter the formula: = MIN (D6: D11,25) -> press Enter -> the smallest value is:
- Where the values are all text or logical values -> the function returns the value 0, and ignores those values:
Above are instructions and some specific examples when using the MIN function in Excel.
Good luck!
You should read it
- MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
- BINOM.INV function - The function returns the smallest value with cumulative binomial distribution greater or equal to the standard value in Excel
- MEDIAN function - The function returns the median of the given numbers in Excel
- SMALL function - The function returns the kth smallest value in a dataset in Excel
- RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excel
- How to use ADDRESS function in Excel
- TIME function - Function returns decimal numbers for a specific time value in Excel
- Save time with these text formatting functions in Microsoft Excel
- PI (PI Function) in Excel - How to use PI numbers in Excel
- DMIN () function (returns the minimum value by condition) in Excel
- How to use the IF function in Excel