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.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)
New Dynamic Array Functions in Excel