Studies show that good grammar leads to more promotions and higher salaries. Write with Grammarly

MAXA Function in Excel

In this post, you’ll learn about MAXA Function, syntax and the way of using MAXA Function in Excel spreadsheet.

What is MAXA Function?

The Excel MAXA Function calculates and returns the largest numeric value in a given data. MAXA Function ignores empty cells but calculates logical values as 1 and 0.

In financial analysis, MAXA can be useful in calculating maximum numeric value and ignoring empty cells. MAXA Function introduced in MS Excel 2007.

Syntax

 =MAXA(value 1, [value 2],..)
Arguments:
  • = – built-in function.
  • MAXA() – function name.
  • value 1 – (required) is a range that contains a numeric value.
  • value 2 – (optional) is a range that contains a numeric value.

Notes:

  • Ignores empty cells.
  • MAXA Function evaluates logical value TRUE and FALSE as 1 and 0.
  • Arguments can be provided as numbers, names, arrays, references logical values, or text.
  • If arguments contain no numbers, MAXA returns 0.
  • In a cell, a ‘number as text’ is calculated as zero
  • #VALUE! Error – if the values are supplied directly as non-numeric.

Difference between MAX Function and MAXA Function:

MAX Function MAXA Function
MAX Function returns the largest
numeric value of the data.
MAXA Function returns the largest
numeric value of the data.
Ignores logical values.
Calculates logical values TRUE and FALSE
as 1 and 0.
Calculates text values of numbers
when directly given as
values in the cell.
Calculates text values of
numbers when directly given as
values in the cell.
Ignores text values. Calculates text values as 0.

How to use MAXA Function in Excel ?

MAXA Function is used to calculate the largest value of the given data.

Example:

STEP 1:

Open the workbook in your Microsoft Excel.

STEP 2:

Enter the data in the workbook.

How to use MAXA Function in Excel ?

In this example, we entered some random values to calculate MAXA Function.

STEP 3:

In the new cell, give the syntax. Always start with ‘ =’ for every functions, MAXA Function name, followed by the open parenthesis, to the arguments of the syntax.

How to use MAXA Function in Excel ?

The values are from the cell A3:A8.

STEP 4:

Press enter to get the MAXA values.

How to use MAXA Function in Excel ?

Return 76. It is the largest values among the given values.