MAX() – Finds the highest number in a range

The MAX() function returns the largest numeric value from a specified range of cells.

Syntax

MAX(range)

range: A continuous range of cells from which you want to find the maximum numeric value (e.g., T1A1:T1A10).

Basic example

MAX(T1A1:T1A10)

This formula finds the largest number in cells T1A1 through T1A10.

Example outputs:

If cells T1A1:T1A10 contain [1, 2, 3, 4, 5, 6, 7, 8, 9, 10], the formula returns 10.
If cells T1A1:T1A5 contain [10, "text", 50, empty_cell, 25], the formula returns 50.
If cells T1A1:T1A3 contain [-10, -5, -20], the formula returns -5.

Key features

Largest numeric value: Identifies and returns the highest number within the given range.
Ignores text: Text values within the range are ignored and do not affect the result.
Ignores empty cells: Blank cells within the range are ignored.

Practical uses

Finding the highest score on a test or the peak value in a series of measurements.
Identifying the largest sale amount or the maximum temperature recorded.

Common mistakes

Incorrect range specification: Ensure the range is correctly defined.
Numbers formatted as text: If numbers are stored as text and not automatically converted by MathGrid for comparison, they will be ignored, potentially leading to an incorrect maximum value being returned.
Empty or all-text range: If the range contains no numeric values (all cells are empty or contain text), MAX() will return an error.