Returns the maximum of a list of arguments, including text and logical entries.
MAXA(value1, value2, ... value30)
value1 to value30 are up to 30 values or ranges, which may include numbers, text and logical values. Text is evaluated as 0. Logical values are evaluated as 1 (TRUE) and 0 (FALSE).
MAXA(2, 6, 4)
returns 6, the largest value in the list.
where cells B1, B2, B3 contain -1, -2, and apple returns 0, the value of the text.
returns 1, the value of TRUE.