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.
=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.
|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.
|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|