MIN and MAX functions in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

This data shows a list of numbers in cells A1 to A5 representing daily sales amounts.

Cell	Value
A1	10
A2	25
A3	7
A4	30
A5	15

Formula Trace

=MIN(A1:A5) & " and " & MAX(A1:A5)

Step 1: MIN(A1:A5)

Step 2: MAX(A1:A5)

Step 3: 7 & " and " & 30

Cell Reference Map

    A   
  +-----+
1 | 10  |
2 | 25  |
3 | 7   |
4 | 30  |
5 | 15  |
  +-----+

Arrows: MIN and MAX functions read all values from A1 to A5.

The formula uses the range A1:A5 to find the minimum and maximum values among these cells.

Result

    A           B          
  +-----+----------------+
1 | 10  | 7 and 30       |
2 | 25  |                |
3 | 7   |                |
4 | 30  |                |
5 | 15  |                |
  +-----+----------------+

Cell B1 shows the result of the formula combining MIN and MAX values.

The final result '7 and 30' appears in cell B1, showing the smallest and largest numbers from the list.

Sheet Trace Quiz - 3 Questions

What does the MIN function return for the range A1:A5?

A 15

B 10

C 7

D 30

Key Result

MIN(range) finds the smallest number; MAX(range) finds the largest number in the same range.