SheetFX
≡
<< Go back to all functions

MAXA

The MAXA function in Google Sheets is a useful tool to find the maximum numeric value in a dataset. Whether you're analyzing sales data, tracking stock prices, or calculating exam scores, the MAXA function simplifies the task. Follow our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: MAXA(value1, value2)

Parameters:

  • value1: The first value or range to consider for the maximum.
  • value2: Additional numbers or ranges to consider.

Step-by-Step Tutorial

  1. Using MAXA with individual numbers:

    • Example: =MAXA(10, 5, 12)
    • Result: 12

  2. Using MAXA with a range of cells:

    • Example: If A1:A5 has the values 5, 10, 3, 8, 7, then =MAXA(A1:A5) will return 10.

Use Cases and Scenarios

  1. Sales Analysis: Identify the product with the highest sales figure.
  2. Stock Market Analysis: Find the maximum stock price for a given period.
  3. Grading System: Determine the highest score in a class.

Related Functions

  • MIN: Find the smallest value in a set.
  • MINA: Like MAXA, but it evaluates text and other data types as well.

Related Articles