Using the Excel MAXA Function
SummaryThe Excel MAXA function returns the largest numeric value from a range of values. Unlike the MAX function, MAXA will evaluate the logical operators TRUE and FALSE as 1 and 0 (zero), respectively. The function ignores empty cells.
To find the smallest number from a range of values while considering logical operators, use the MINA function.
Syntax=MAXA (value1, [value2], ...)
Syntax BreakdownValue 1
Required. The first argument for which you want to find the largest value. Entries can be numbers, names, references, arrays, logical values, or the text representation of a number.
Value 2 and subsequent arguments are optional. The function can accept up to 255 arguments.
Usage NotesMAXA returns the largest value from a set of provided values. The function ignores empty cells, but will accept TRUE and FALSE and treat them as 1 and 0 (zero), respectively. The function returns 0 (zero) if the arguments contains no numbers.
Arguments with error values or text that cannot be translated into a number will result in an error.
Use the MAX function if you do not want to include logical values and text representations of numbers.
Numbers Entered as Text
The official Microsoft documentation notes one difference between MAX and MAXA is that MAXA will evaluate the text representation of a number and MAX will not. However, there does not appear to be a difference when evaluating numbers as text for either function.