Excel functions / Statistics
MAXA function
The largest value, counting text in a range as 0 and TRUE as 1.
Syntax
=MAXA(value1, [value2], …)
Arguments
value: Values, cells or ranges.
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
Text counts as 0
A B C 1 Value 2 -5 0 3 n/a 4 -2 In C2:
=MAXA(A2:A4)→ 0MAX would give -2, ignoring the text.
Common mistakes
- Surprise zeros. A note such as "n/a" among negative numbers makes MAXA give 0. Use MAX unless text should count.
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.
- Czech: MAXA
- Danish: MAKSV
- Dutch: MAXA
- Finnish: MAKSA
- French: MAXA
- German: MAXA
- Hungarian: MAXA
- Italian: MAX.VALORI
- Norwegian: MAKSA
- Polish: MAX.A
- Portuguese (Brazil): MÁXIMOA
- Portuguese (Portugal): MÁXIMOA
- Russian: МАКСА
- Spanish: MAXA
- Swedish: MAXA
- Turkish: MAKA