FormulaCraft

MAX / MIN

MAX returns the highest value in a range and MIN the lowest, ignoring text and blank cells. For conditional versions, use MAXIFS and MINIFS.

Excel
=MAX(B2:B100)
Google Sheets
=MAX(B2:B100)

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. 1MAX(B2:B100) returns the largest number.
  2. 2MIN(B2:B100) returns the smallest.
  3. 3For a conditional max or min, use MAXIFS / MINIFS.

Need a version for your data?

Try: “Find the highest value in column B”

Related

SUMIFSUMIFSCOUNTIF

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

Last reviewed: