Excel functions / Statistics

MINA function

The smallest value, counting text in a range as 0 and TRUE as 1.

Syntax

=MINA(value1, [value2], …)

Arguments

When to use it

MINA gives the smallest value like MIN, but in a range it counts text and FALSE as 0 and TRUE as 1. A column with a note in it can therefore have a minimum of 0.

Examples

  1. A note counts as 0

    ABC
    1Value
    2120
    3pending
    48

    In C2: =MINA(A2:A4) → 0

    MIN would give 8.

    Try this example

Common mistakes

MINA in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try MINA in the playground

Related functions