ID EN
…
#Statistical

MINA

Excel Functions

Return smallest value.

Syntax

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

Arguments

Parameter Description
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.

Return Value

Smallest numeric value

Details

The MINA function returns the smallest numeric value in a range of values. Like the MIN function, MINA ignores empty cells. However, unlike the MIN function, MINA evaluates the logical values TRUE and FALSE as 1 and 0, and evaluates text as zero when these values appear in a range or cell reference. The MINA function takes multiple arguments in the form number1, number2, number3, etc. up to 255 total. Arguments can be a hardcoded constant, a cell reference, or a range, in any combination. Like the MIN function, the MINA function returns the smallest number in the supplied data: MINA can be used with constants, cell references, or ranges: The primary difference between MIN and MINA is that MINA evaluates TRUE and FALSE values as 1 and 0, and text values as zero when these values appear in a

Examples

Examples

Like the MIN function, the MINA function returns the smallest number in the supplied data:

EXCEL 
=MIN(12,17,25,11,23) // returns 11
=MINA(12,17,25,11,23) // returns 11
Examples

MINA can be used with constants, cell references, or ranges:

EXCEL 
=MINA(5,10)
=MINA(A1,A2,A3)
=MINA(A1:A10)
MINA vs. MIN

Note that MIN and MINA both evaluate numbers as text when supplied directly as arguments:

EXCEL 
=MINA(5,"3") // returns 3
=MIN(5,"3") // returns 3

See Also

MIN MAX MAXA SMALL RANK