MAXA

Excel Functions

Return largest value.

Syntax

EXCEL

=MAXA(value1, [value2], ...)

Arguments

Parameter	Description
`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.

Return Value

Largest numeric value

Details

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. Like the MAX function, the MAXA function returns the largest number in the supplied data: MAXA can be used with constants, cell references, or ranges: 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 r

Examples

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

EXCEL

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

Examples

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

EXCEL

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

MAXA vs. MAX

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

EXCEL

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

MAXA

Syntax

Arguments

Return Value

Details

Examples

See Also