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,

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

## 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,