maxa

Maximum value, treating text as 0 and TRUE as 1.

Syntax

v = maxa(number1, number2, ...)

Description

Like max but counts text values as 0 and logical TRUE as 1 in the comparison. Useful when text in a range should not be silently ignored.

Example

maxa(-1, 'text', 2)    % 2

See also

• max — Maximum value along a dimension, or elementwise maximum of two inputs.
• mina — Minimum value, treating text as 0 and TRUE as 1.
• maxifs — Maximum value among cells meeting multiple criteria.