 # How To Use MAXA()

Description

Returns the maximum numeric value in a dataset.

Common Questions about the MAXA Formula:
- What is the MAXA formula in Google Sheets?
- How does the MAXA formula work?
- How can I use the MAXA formula?

How can the MAXA formula be used appropriately:
The MAXA formula can be used to calculate the maximum value in a range of cells that contain numbers or logical values (TRUE or FALSE). It can also work with text, dates, and other elements.

How can the MAXA formula be commonly mistyped:
Those unfamiliar with the MAXA formula may accidentally type “Max” instead of “MAXA”, or type “MAXA” instead of “MAX”.

What are some common ways the MAXA formula is used inappropriately:
The MAXA Formula can be used inappropriately when it is used to calculate the maximum value of a range of cells that contain non-numerical, non-logical values, such as text, dates, or other elements.

What are some common pitfalls when using the MAXA formula:
Some common pitfalls when using the MAXA formula include using the wrong syntax, not ensuring that the range of cells includes only numbers and logical values, and not ensuring that the range of cells is continuous.

What are common mistakes when using the MAXA Formula:
Common mistakes with the MAXA Formula include not setting up the range of cells correctly, not including all the cells in the range, and not understanding how the formula works.

What are common misconceptions people might have with the MAXA Formula:
Many people often confuse the MAXA Formula with the MAX formula, which calculates the maximum value of a range of cells, but doesn’t work with text, dates, or any other elements.

How To Actually Use MAXA() in Sheets

`MAXA(value1, value2)`

0Better Sheets Tutorials

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Find more formulas here at Better Sheets.

Maxa function example in excel

This video shows you how to get largest value using maxa formula in MS Excel 2019 Office 365.

Better Sheets