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.
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.
STEP 4:
Press enter to get the MAXA values.
Return 76. It is the largest values among the given values.