Table of Contents
About
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.
Function Type
Statistical
Purpose
Get the largest value in a set of values
Return value
A number equivalent to the largest value
Syntax
=MAXA(value1, [value2],...)
Arguments
value1– can be a direct value, cell reference or range reference.
value2– [optional] can be a direct value, cell reference or range reference
Example
Notes
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)