The Excel MINA function returns the smallest numeric value in a range of values. The MINA function ignores empty cells, but evaluates the logical values TRUE and FALSE as 1 and 0, respectively.
Return smallest value.
Smallest numeric value
=MINA (value1, [value2], ...)
value1 - Number, reference to numeric value, or range that contains numeric values.
value2 - [optional] Number, reference to numeric value, or range that contains numeric values.
Like the MIN function, the MINA function returns the smallest numeric value in a supplied set of data. For example, the MINA function can return the lowest test score, the fastest time in a race, the lowest temperature, or the smallest sales number. Arguments can be provided as constants, or as cell references or ranges:
The primary difference between MIN and MINA is that MINA evaluates TRUE and FALSE values as 1 and 0 respectively. Microsoft documentation also suggests that MINA evaluates numbers entered as text differently from MIN:
If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MINA function.
This is a bit confusing. In my testing, MIN and MINA both evaluate text representations of numbers when supplied directly as arguments. For example:
=MINA("5",10)// returns 5=MIN("5",10)// also returns 5
The difference appears to be that when text values exist in a cell reference, MINA evaluates them as zero in the calculation, whereas MIN simply ignores them. For example, if A1 contains "5", and A2 contains 10:
The Excel SMALL function returns numeric values based on their position in a list ranked by value. In other words, it can retrive "nth smallest" values - smallest value, 2nd smallest value, 3rd smallest value, etc.
The Excel RANK function returns the rank of a numeric value when compared to a list of other numeric values. RANK can rank values from largest to smallest (i.e. top sales) as well as smallest to largest (i.e. fastest time) values, using an...
Excel Formula Training
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.