MAXA Function Explained
The MAXA function in Microsoft Excel returns the maximum value in a range of values, including numbers, text, logical values, and errors. It ignores empty cells, logical values, and text values. It can take up to 255 arguments, and returns the maximum value of all the arguments.
MAXA Function Syntax
MAXA(value1, [value2], ...)
value1– The first value or range of values to consider when finding the maximum value.value2– (optional) Additional values or ranges of values to consider when finding the maximum value.