Excel MINA Function

Using the Excel MINA Function


The Excel MINA function returns the smallest numeric value from a range of values. Unlike the MIN function, MINA will evaluate the logical operators TRUE and FALSE as 1 and 0 (zero), respectively. The function ignores empty cells.

To find the largest number from a range of values while considering logical operators, use the MAXA function.


=MINA (value1, [value2], ...)

Syntax Breakdown

Value 1
Required. The first argument for which you want to find the smallest value. Entries can be numbers, names, references, arrays, logical values, or the text representation of a number.

Value 2
Value 2 and subsequent arguments are optional. The function can accept up to 255 arguments.

Usage Notes

MINA returns the smallest value from a set of provided values. The function ignores empty cells, but will accept TRUE and FALSE and treat them as 1 and 0 (zero), respectively. The function returns 0 (zero) if the arguments contains no numbers.

Arguments with error values or text that cannot be translated into a number will result in an error.

Use the MIN function if you do not want to include logical values and text representations of numbers.

Numbers Entered as Text
The official Microsoft documentation notes one difference between MIN and MINA is that MINA will evaluate the text representation of a number and MIN will not. However, there does not appear to be a difference when evaluating numbers as text for either function.