Buzz
This article introduces you to the MINA function, one of the essential statistical functions in Excel.
Description: The function returns the smallest value among the provided numbers, encompassing both text and logical values.
Syntax: MINA(value1, [value2], ...)
In this context:
- value1, [value2], ...): These are the values to find the median, where value1 is a mandatory parameter, and other values are optional, with a maximum of 255 values.
Note:
- The argument values must be numbers, names, arrays, or references containing numbers.
- Logic values, where True is considered as 1, and False is considered as 0.
- If the argument is an array reference containing text or logic values -> these values are ignored, but 0 is still counted.
- If the arguments do not contain numbers -> the function returns the value 0.
- Text or error values that cannot be converted into numbers as arguments -> cause an error for the function.
- When you prefer not to consider text and logic values -> use the MIN function.
Example:
Calculate the smallest value among the data in the table below:
- In the cell where you want to calculate, enter the formula : =MINA(D6:D11)
- Press Enter -> the smallest value, including both text and logic, is:
- Here, the returned value is 0, corresponding to the value of False.
- In the case where True is the smallest value -> the function returns the value 1
- In the case where False is the smallest value -> the function returns the value 0.
Here is a guide along with some specific examples of using the MINA function in Excel.
Wishing you all the best!
