MAXA Function

Returns the largest value, counting text as 0 and TRUE as 1.

Category

Statistical

Available in

All versions, Microsoft 365

Returns

A number

Want to practice MAXA in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

MAXA works like MAX, but in a range it also counts text (as 0), TRUE (as 1) and FALSE (as 0). Empty cells are still skipped.

It only gives a different answer from MAX when text or logical values would change the result — for example when every number is negative.

Syntax

=MAXA(value1, [value2], …)

Arguments

ArgumentRequired?What it does
value1YesA value, cell or range.
value2, …NoUp to 255 more values, cells or ranges.

Examples

Example 1 — MAX vs MAXA with all-negative numbers

Monthly results for a loss-making project, with one month not reported.

D2fx=MAXA(B2:B5)
ABCD
1MonthResultMAXA
2Jan-12000
3Feb-300MAX
4Marn/a-300
5Apr-850
=MAXA(B2:B5) Explain

MAXA treats "n/a" as 0, which beats every loss; MAX ignores it and returns −300.

Common mistakes

  • Surprising zeros. Any text in the range counts as 0, which can quietly become the maximum. Use MAX if text should be ignored.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.