MINA function - The function returns the smallest value in the given numbers including text and logical values ​​in Excel

The following article introduces you to the MINA function - one of the functions in the statistical function group is very popular in Excel.

MINA function - The function returns the smallest value in the given numbers including text and logical values ​​in Excel Picture 1

Description: The function returns the smallest value in the given numbers including text and logical values.

Syntax: MINA (value1, [value2], .)

Inside:

- value1, [value2], .): The values ​​that you want to find the median, where value1 is the required parameter, other values ​​are optional and contain up to 255 value parameters .

Attention:

- The value of the argument must be a number, name, array or reference containing numbers.

- A logical value of True is considered 1, and a False value is considered to be 0.

- 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 do not want to include both text and logical values ​​-> use the MIN function .

For example:

Calculate the minimum value of the values ​​in the following data table:

MINA function - The function returns the smallest value in the given numbers including text and logical values ​​in Excel Picture 2

- In the cell to calculate enter the formula : = MINA (D6: D11)

MINA function - The function returns the smallest value in the given numbers including text and logical values ​​in Excel Picture 3

- Press Enter -> the smallest value including the text value and logic is:

MINA function - The function returns the smallest value in the given numbers including text and logical values ​​in Excel Picture 4

- Here the return value is 0 corresponding to the value of False.

- Where True value is the smallest value -> the function returns the value 1

MINA function - The function returns the smallest value in the given numbers including text and logical values ​​in Excel Picture 5

- Where the value of False is the smallest value -> the function returns the value 0.

MINA function - The function returns the smallest value in the given numbers including text and logical values ​​in Excel Picture 6

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

Good luck!