MAXA

Returns the largest from the specified arguments, including logical and text values.

Syntax

MAXA( Any value1, [Any value2], ... ) → Number

Parameters

value1
value2
…

One or more numbers, texts, or logical values for which to find the maximum value.

Remarks

The arguments can be either numbers, text, or logical values, or cells or arrays, containing numbers, text, or logical values. Text values are treated as zeros. Logical TRUE is treated as 1, and FALSE is treated as 0. Empty cells are not included.

Example

Formula

=MAXA(A1:A5)
=MAXA(A1:A5,"V",1>0)

See Also

Function Reference
MAX Function
MIN Function
MINA Function