Formulas > =MAXA()

# How To Use MAXA() Function in Google Sheets

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)`

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Maxa function example in excel

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

Generate a MAXA() formula for your needs with AI

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.

Asa

Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.

Better Sheets