fx =MAX(A1:A100)ABCJan Score8782.3Feb Score92Mar Score78
📈 Statistical

MAX / MIN Formula for Statistical

Find the largest or smallest value in a range. Copy-paste ready for Excel, Google Sheets, and Airtable.

=MAX(A1:A100)
When you need this: When you need to find the highest test score (A1:A100) to identify the top performer in your class.

How it works

  1. 1MAX scans the range (A1:A100) and returns the largest value.
  2. 2MIN scans the same range and returns the smallest value.
  3. 3Both ignore text and empty cells automatically.

Variations

Find max excluding zeros
=MAX(IF(A1:A100>0,A1:A100))
Find second-highest value
=LARGE(A1:A100,2)

Related Formulas

AVERAGE — Calculate the average of a rangeStatisticalCOUNTIF — Count cells that meet a conditionStatisticalCOUNTIFS — Count cells meeting multiple conditionsStatisticalAVERAGEIF — Average values meeting a conditionStatistical

Need a formula that's not here?

Generate custom formula →