If you want to learn how to use Excel MINA function this tutorial will give you an answer. Just as it is with using other different functions in Excel, there are also several ways to use MINA function. In this post, we’ll consider how to use the MINA function with syntax in Excel.
Excel MINA Function
=MINA (value1, [value2], [value3], [value4] ...)
The Excel MINA function receives a set of values and returns the lowest numeric value within the supplied data set. It ignores empty cells (if any) and evaluates TRUE as 1 and FALSE as 0. The Excel MINA function can also return the smallest test score, the lowest temperature, the fastest time in a race, or the least sales number. The arguments of the function are values that we want to compare, value1 is the obligatory argument, and the other ones are optional.
In the following example we will see how you can use the Excel MINA function to get the smallest value of a range of numerical values:
Figure 1. Excel MINA Function
In figure 1 above, column G (MINA) contains the smallest of a range of numerical values.
Arguments can be provided as:
- The range that consists of numeric values:
- Cell reference to numeric values:
=MINA (B6, C6, D6, E6, F6)
If arguments contain no numbers, MINA returns 0.
The major difference between the MINA function and MIN function is that MINA function evaluates TRUE as 1 and FALSE as 0.
In Figure 1 above,
=MIN (B9:F9) returns 7
=MINA (B9:F9) returns 1
The MINA function in the current Excel version also accepts about 255 arguments. There are claims from Microsoft documentation that the MINA function can also evaluate numbers entered as text. But I have not been able to replicate this behavior. In which case, MINA and MIN seem to evaluate numbers the same way:
=MINA ("25", 12) returns 12
=MIN ("12", 25) also returns 12