MAXA Function in Excel

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

MAXA Function in Excel 1

  • 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
Result

MAXA Function in Excel 2

previous-small MAXA Function in Excel                                                                                                                next_small MAXA Function in Excel