The MAXA function returns the largest value from a supplied set of numerical values, while counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1.

Syntax

=MAXA(num_1,[num_2], … )

Note: Beginning with Excel 2007, you can enter up to 255 number arguments to the function. Excel 2003 would only accept up to 30 number arguments.

Arguments

Argument Description
num_1,
[num_2], …
The number arguments are a set of one or more numeric values, or arrays of numeric values, that you want to return the largest value of.

  Number values can be supplied either directly to the function, as cells containing numeric values, or as values returned from other excel formulas.

Examples

  A B C D E
1 Value   Formula Result Notes
2     =MAXA(1,5,10) 10  
3 -1    =MAXA(A2,TRUE) 1 TRUE is counted as the value 1
4 -5 FALSE =MAXA(A3:B3) 0 FALSE is counted as the value 0
5 -10 text =MAXA(A4:B4) 0 “text” is counted as the value 0
6     =MAXA(A2:A6) -1 Empty cells A2 and A6 are ignored
Excel MAX and MAXA Functions

The Excel MAX and MAXA functions are very similar. The difference is, when an argument is supplied to the function as a reference to a cell or an array of cells:

  • MAX ignores logical and text values
  • MAXA counts the logical value TRUE as 1, the logical value FALSE as 0 and text values as 0

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the arguments are supplied directly to the function and cannot be recognized as numeric values