Stat Β· Nov 16, 2026

The MAX function,
measured & explained.

MAX returns the greatest number among its arguments. It scans ranges for numeric values and ignores text and blanks, so a stray label never wins. With no numbers present it returns 0 rather than an error, which makes it safe for dashboards. Use it for peak sales or top score.

D1
fx
=MAX(…)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 β€” Anatomy

How MAX works

Returns a number. Text and blanks in ranges are ignored; no numbers gives 0.

=MAX(number1, number2, ...)
number1The first number, reference or range to search.
number2, ...Optional additional numbers or ranges (up to 255).
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 β€” One range, four readings

MAX vs MIN vs AVERAGE vs COUNT

The same range read four ways, measured live. Click any row to load it.

Aggregations, measured

ExpressionResultWhy
=MAX(A2:A6)92Top score
=MAX(B2:B6)1500Peak sales
=MAX(A2:A8)92Blank and text ignored
=MAX(10,20,30)30Direct numbers
=MAX(A2:A4)92First three scores
=MAX(0,A2:A6)92Floor at 0
=MAX(-5,-10)-5Larger of two negatives
=MAX(B2:B8)1500All sales
⚠ MAX ignores stored-as-text numbers, so a text column returns 0. Convert with VALUE before taking MAX.
MAX returns 0 when there are no numbers, unlike AVERAGE which returns #DIV/0! β€” safe for dashboards but can hide missing data.
// 03 β€” Try it live

Interactive MAX playground

Edit the table or type any formula β€” the engine evaluates instantly. Load a preset to find peaks and compare aggregations.

A1Sample data β€” click any cell to edit, the formula re-evaluates live
Result
β€”
βœ“ readyHyperFormula 3.5
// 04 β€” Error library

The real-world error library

8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User β€” each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

// 05 β€” Cross-platform

Where MAX works

MAX is a core statistical function present in every Excel version and platform.

PlatformSupportNotesGotcha
βœ“ Supported full MAX◐ Partial works with caveatsCompiled from public docs Β· verify against your build
// Go deeper

Master stat

MAX is one piece. The full course walks the toolkit end to end with live, measured examples.

  • Ignores text and blanks
  • Returns 0 on empty, not an error
  • MAX(0,range) floors at zero
  • MAXIFS for conditional max
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 β€” FAQ

Frequently asked