Formulas and functions > Functions from A to Z

Syntax:

MAXA(Value1 [, Value2, Value3 ...])

Description:

The MAXA function is almost identical to the MAX function (see note). Thus, it returns the largest value within the given values.

Number1, Number2, etc., are the numbers to be evaluated.

Note:

Unlike MAX, MAXA also evaluates logical values and text: FALSE is evaluated as 0, while TRUE is evaluated as 1.

Empty cells, however, are also ignored here.

Example:

MAXA(5, 7, 4, 9) returns 9

If the cells A1:A3 contain -1, -2 and TRUE:

MAXA(A1:A3) returns 1 (since TRUE = 1)

MAX(A1:A3), on the other hand, results in -1 (because the logical value TRUE is ignored in the MAX function)

MAXA (maximum)