## Summary

The Excel MAXA function returns the largest numeric value in a range of values. The MAXA function ignores empty cells, but evaluates the logical values TRUE and FALSE as 1 and 0, and evaluates text as zero.

## Purpose

Return largest value.

## Return value

Largest numeric value

## Syntax

``=MAXA(value1,[value2],...)``
• value1 - Number, reference to numeric value, or range that contains numeric values.
• value2 - [optional] Number, reference to numeric value, or range that contains numeric values.

## How to use

The MAXA function returns the largest numeric value in a range of values. Like the MAX function, MAXA ignores empty cells. However, unlike the MAX function, MAXA evaluates the logical values TRUE and FALSE as 1 and 0, and evaluates text as zero when these values appear in a range or cell reference.

The MAXA function takes multiple arguments in the form number1, number2, number3, etc. up to 255 total. Arguments can be a hardcoded constant, a cell reference, or a range, in any combination.

### Examples

Like the MAX function, the MAXA function returns the largest number in the supplied data:

``````=MAX(12,17,25,11,23) // returns 25
=MAXA(12,17,25,11,23) // returns 25
``````

MAXA can be used with constants, cell references, or ranges:

``````=MAXA(5,10)
=MAXA(A1,A2,A3)
=MAXA(A1:A10)
``````

### MAXA vs. MAX

The primary difference between MAX and MAXA is that MAXA evaluates TRUE and FALSE values as 1 and 0, and text values as zero when these values appear in a range or in a cell reference. You can see this behavior in the range I7:I12 of the example shown. While the MAX function ignores the logical and text values completely, the MAXA function includes these values when calculating a maximum value.

Note that MAX and MAXA both evaluate numbers as text when supplied directly as arguments:

``````=MAXA(5,"10") // returns 10
=MAX(5,"10") // also returns 10
``````

### Notes

• MAXA ignores empty cells, but evaluates logical values and text values.
• Arguments can be provided as numbers, names, arrays, or references.
• If arguments contain no numeric values, MAXA returns 0.
• To ignore logical values and text, see the MAX function.

Author

### Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.