Excel MAXA function

Function              MAXA

Description        Excel MAXA function returns the largest value (numeric) in an array. MAXA function includes logical values like TRUE and FALSE. TRUE or FALSE are evaluated as 1 and 0.

Syntax  MAXA(value1, [value2], …)

value1  Value, reference or range that contains numeric or logical values.

value2  [optional] Value, reference or range that contains numeric or logical values.

Example:

MAXA function can be entered like this ways

=MAXA(12,114,67,45,89,97)=114

=MAXA(A1,A2,A3,B1,B2,B3)=114

=MAXA(A1:B3)=114

Usage Notes:

• The MAXA function doesn’t include empty cells.
• The MAXA function accepts up to 255 arguments.
• Logical values TRUE or FALSE are evaluated as 1 and 0.