MIN and MAX functions in Excel - Step-by-Step Guide

Introduction

MIN and MAX functions help you find the smallest and largest numbers in a list. They save time when you want to quickly see the lowest or highest value in your data.

When you want to find the lowest sales number in a month.

When you need to know the highest score in a test results list.

When checking the smallest or largest expense in a budget sheet.

When comparing temperatures recorded over several days to find the coldest or hottest day.

When summarizing data to find minimum or maximum values for quick insights.

Steps

Step 1: Click

- a blank cell where you want the result

The cell is selected and ready for input

Step 2: Type

- the formula bar

The formula appears in the formula bar

💡 Start with =MIN( or =MAX( depending on what you want

Step 3: Select

- the range of cells containing numbers

The selected cells are highlighted and their addresses appear inside the parentheses

Step 4: Type

- the formula bar

The formula is complete with closing parenthesis

💡 Example: =MIN(A1:A10) or =MAX(B1:B10)

Step 5: Press

- Enter key

The cell shows the smallest or largest number from the selected range

Before vs After

Before

Cells A1 to A5 contain numbers: 10, 25, 7, 30, 15

After

Cell B1 shows 7 when formula =MIN(A1:A5) is entered; Cell B2 shows 30 when formula =MAX(A1:A5) is entered

Settings Reference

Function name

📍 Formula bar

Choose MIN to find smallest number, MAX to find largest number

Default: None

Cell range

📍 Formula bar inside parentheses

Defines which cells to check for minimum or maximum value

Default: None

Common Mistakes

Typing =MIN or =MAX without parentheses

Excel expects a range or numbers inside parentheses to work

Always include parentheses with the range or numbers, like =MIN(A1:A5)

Selecting cells with text or empty cells only

MIN and MAX ignore text but if no numbers are found, result is 0 or error

Make sure the selected range contains numbers to get meaningful results

Summary

MIN finds the smallest number in a selected range.

MAX finds the largest number in a selected range.

Always include the cell range inside parentheses after the function name.