MAXA

Definition: MAXA is a function that returns the maximum value in a range of cells, and treats text and logical values as numbers.

Syntax: =MAXA(number1, [number2], …)

Situation: This formula is appropriate when you need to find the maximum value in a range of cells, and treat text and logical values as numbers.

Example: If you have a set of numbers 2, 4, 6, and a text value “apple”, the maximum value can be found using the formula =MAXA(2, 4, 6, “apple”), which returns 6.