The following article introduces you to the MINA function - one of the functions in the statistical function group is very popular in Excel.
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:
- In the cell to calculate enter the formula : = MINA (D6: D11)
- Press Enter -> the smallest value including the text value and logic is:
- 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
- Where the value of False is the smallest value -> the function returns the value 0.
Above are instructions and some specific examples when using the MINA function in Excel.
Good luck!