The MIN and MAX functions in Sheets allow you to find the minimum (lowest) and maximum (highest) figure in a range of figures.

MIN Function

The MIN Function is a quick and easy way of finding the minimum figure in a set of figures in Sheets.

What it does…

Finds the minimum figure.

Syntax

=MIN(cellref:cellref)

=MIN(cellref:cellref,cellref:cellref)

Examples

=MIN(A1:A10)

=MIN(1,2,3,4,5)

=MIN(1,2,A2:A12)

=MIN(B2:B8,C2:C8,D2:D8)

Instructions

To use the MIN function in Sheets,

  1. Click on the cell where you want your answer
  2. Click on the Functions icon (the Greek letter sigma – looks like a backwards E)
  3. Choose MIN
  4. Click and drag over the cells where you want to find the minimum

Shortcut


MAX function

The MAX Function is a quick and easy way of finding the highest figure in a set of figures in Sheets.

What it does…

Finds the highest figure.

Syntax

=MAX(cellref:cellref)

=MAX(cellref:cellref,cellref:cellref)

Examples

=MAX(A1:A10)

=MAX(1,2,A2:A12)

=MAX(1,2,3,4,5)

=MAX(B2:B8,C2:C8,D2:D8)

Instructions

To use the MAX function in Sheets,

  1. Click on the cell where you want your answer
  2. Click on the Functions icon (the Greek letter sigma – looks like a backwards E)
  3. Choose MAX
  4. Click and drag over the cells you want to average

Shortcut

Click on the download button above, if you want to download a copy of the example used on this page into your Sheets account.


I hope this page about the MIN and MAX functions in Sheets was useful to you. Other useful functions in Sheets include AVERAGE and SUM. To return to the resources page, just click here.