MIN function - The function returns the smallest value in the given numbers in Excel

MIN function: The function returns the smallest value in the given numbers. Syntax: MIN (number1, [number2], ...)

The following article introduces you to MIN - 1 of the functions in the group of statistical functions that are very popular in Excel.

MIN function - The function returns the smallest value in the given numbers in Excel Picture 1MIN function - The function returns the smallest value in the given numbers in Excel Picture 1

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:

MIN function - The function returns the smallest value in the given numbers in Excel Picture 2MIN function - The function returns the smallest value in the given numbers in Excel Picture 2

- Calculate the minimum value in the number values . In the cell to calculate enter the formula : = MIN (D6: D11)

MIN function - The function returns the smallest value in the given numbers in Excel Picture 3MIN function - The function returns the smallest value in the given numbers in Excel Picture 3

- Press Enter -> minimum value is:

MIN function - The function returns the smallest value in the given numbers in Excel Picture 4MIN function - The function returns the smallest value in the given numbers in Excel Picture 4

- Calculate the smallest value in the numbers number and 25 -> enter the formula: = MIN (D6: D11,25) -> press Enter -> the smallest value is:

MIN function - The function returns the smallest value in the given numbers in Excel Picture 5MIN function - The function returns the smallest value in the given numbers in Excel Picture 5

- Where the values ​​are all text or logical values ​​-> the function returns the value 0, and ignores those values:

MIN function - The function returns the smallest value in the given numbers in Excel Picture 6MIN function - The function returns the smallest value in the given numbers in Excel Picture 6

Above are instructions and some specific examples when using the MIN function in Excel.

Good luck!

4.5 ★ | 2 Vote