MIN and MAX functions in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants to know the lowest and highest sales amounts from last month to understand sales performance.

📊 Data: You have a list of daily sales amounts for the last month in a column.

🎯 Deliverable: Create a simple report showing the minimum and maximum sales values from the data.

Sample Data

Date	Sales Amount
2024-05-01	250
2024-05-02	300
2024-05-03	150
2024-05-04	400
2024-05-05	350
2024-05-06	200
2024-05-07	450
2024-05-08	100
2024-05-09	500
2024-05-10	300

1

Step 1: Select a cell where you want to show the minimum sales amount.

Click on an empty cell, for example, C12.

Expected Result

Cell C12 is selected and ready for formula input.

2

Step 2: Enter the formula to find the minimum sales amount from the Sales Amount column.

=MIN(B2:B11)

Expected Result

The cell shows 100, which is the smallest sales amount in the list.

3

Step 3: Select another cell to show the maximum sales amount.

Click on an empty cell, for example, C13.

Expected Result

Cell C13 is selected and ready for formula input.

4

Step 4: Enter the formula to find the maximum sales amount from the Sales Amount column.

=MAX(B2:B11)

Expected Result

The cell shows 500, which is the largest sales amount in the list.

5

Step 5: Label the results for clarity.

In cell B12, type 'Minimum Sales'; in cell B13, type 'Maximum Sales'.

Expected Result

Cells B12 and B13 show labels next to the minimum and maximum values.

Final Result

Date       | Sales Amount
-------------------------
2024-05-01 | 250
2024-05-02 | 300
2024-05-03 | 150
2024-05-04 | 400
2024-05-05 | 350
2024-05-06 | 200
2024-05-07 | 450
2024-05-08 | 100
2024-05-09 | 500
2024-05-10 | 300

Minimum Sales: 100
Maximum Sales: 500

✓The lowest sales amount last month was 100.

✓The highest sales amount last month was 500.

Bonus Challenge

Create a formula to find the difference between the maximum and minimum sales amounts.

Show Hint

Use the formula =MAX(range) - MIN(range) with the same sales data range.