MAXA function in Excel returns the largest value or maximum value from a supplied set of numeric values. Where Text value is considered as 0. Logical Value FALSE is considered as 0 and Logical Value TRUE is considered as 1.
Syntax of MAXA Function in Excel:
MAXA( number1, [number2], … )
Where the number arguments are one or more numeric values from which you want to find the maximum value in Excel
Example of MAXA Function in Excel:
Formula
- Text Value is considered as 0
- Logical Value with FALSE is considered as 0
- Logical Value with TRUE is considered as 1
- In First Example MAXA Function takes up the cell reference and finds the maximum value
- In Second Example MAXA Function takes up the values directly and finds the maximum value