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
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
Arguments
| Argument | Required? | What it does |
|---|---|---|
| value1 | Yes | A value, cell or range. |
| value2, … | No | Up 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.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Month | Result | MAXA | |
| 2 | Jan | -1200 | 0 | |
| 3 | Feb | -300 | MAX | |
| 4 | Mar | n/a | -300 | |
| 5 | Apr | -850 |
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

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.