Excel functions / Statistics

MAXA function

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

Syntax

=MAXA(value1, [value2], …)

Arguments

When to use it

MAXA gives the largest value like MAX, but in a range it counts TRUE as 1 and FALSE and text as 0. That rarely matters for a maximum; MINA is where it shows.

Examples

  1. Text counts as 0

    ABC
    1Value
    2-50
    3n/a
    4-2

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

    MAX would give -2, ignoring the text.

    Try this example

Common mistakes

MAXA 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 MAXA in the playground

Related functions