# 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.

## 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.

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.

The values are from the cell A3:A8.

##### STEP4:

Press enter to get the MAXA values.

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