MAXA function is used to find the largest number from a set of values. The difference between MAX and MAXA function is that the latter evaluates ‘TRUE’ and ‘FALSE’ values as ‘1’ and ‘0’ respectively.
Get the largest value in a set of values
A number equivalent to the largest value
value1– can be a direct value, cell reference or range reference.
value2– [optional] can be a direct value, cell reference or range reference
Numbers in cells formatted as ‘Text’ will be evaluated as ‘0’ by MAXA function.