FormulaCraft

MAX

MAX scans one or more ranges and returns the highest number found, ignoring text and empty cells. It is the go-to function for identifying the top score, highest revenue, or latest date in a dataset.

Excel
=MAX(B2:B5)
Google Sheets
=MAX(B2:B5)
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

MonthRevenue
Jan5200
Feb4800
Mar6100
Apr5900

=MAX(B2:B5)→6100

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1Reference the range you want to search: =MAX(B2:B5).
  2. 2MAX ignores text, blanks, and logical values in the range.
  3. 3The function returns the single largest numeric value found.

Need a version for your data?

Try: “Find the highest sales figure in a column”

Related

COUNTACOUNTBLANKMODE

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: