Home/Formulas/Math/MAX
Matheasy

MAX()

Returns the largest numeric value in a dataset.

Syntax
fx
=MAX(value1, [value2, ...])
Arguments
ArgumentDescription
value1The first value or range to consider.
[value2, ...]Additional values or ranges to consider.
Try it
F2
→
48,200
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • Same skip behavior as MIN: text and empties are ignored. Returns 0 for an all-empty range.
  • For ties, MAX returns the value but says nothing about which cell holds it. Pair with MATCH(MAX(range), range, 0) to find the position.
Related formulas
MIN()
Returns the smallest numeric value in a dataset.
Used by
MIN()
Returns the smallest numeric value in a dataset.
More Math formulas →Keyboard shortcuts for Sheets →