MIN and MAX functions in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the MIN function do in Google Sheets?

The MIN function finds the smallest number in a list of numbers or range of cells.

beginner

What does the MAX function do in Google Sheets?

The MAX function finds the largest number in a list of numbers or range of cells.

beginner

How do you write a formula to find the smallest number in cells A1 to A5?

Use =MIN(A1:A5) to get the smallest number in cells A1 through A5.

beginner

How do you write a formula to find the largest number in cells B1 to B10?

Use =MAX(B1:B10) to get the largest number in cells B1 through B10.

intermediate

Can MIN and MAX functions handle numbers and empty cells together?

Yes, MIN and MAX ignore empty cells and text; only numbers are considered.

What will =MIN(3, 7, 2, 9) return?

A 2

B 9

C 3

D 7

MIN returns the smallest number, which is 2.

Which formula finds the largest value in cells C1 to C5?

A =SUM(C1:C5)

B =MIN(C1:C5)

C =MAX(C1:C5)

D =AVERAGE(C1:C5)

MAX finds the largest number in the range.

If cells A1=5, A2=empty, A3=10, what does =MIN(A1:A3) return?

A 5

B 0

C empty

D 10

MIN ignores empty cells and returns the smallest number, 5.

What happens if you use =MAX() with no arguments?

A Returns 0

B Returns 1

C Returns blank

D Returns an error

MAX requires at least one number or range; otherwise, it returns an error.

Which function would you use to find the lowest price from a list?

A MAX

B MIN

C SUM

D COUNT

MIN finds the smallest value, useful for lowest price.

Explain how to use the MIN function with a range of cells.

Think about finding the lowest value in a list of numbers.

Describe the difference between MIN and MAX functions.

One finds the lowest, the other finds the highest.