← Back to level 1
Level 1Next
MIN
A easy comparison formula for finding the lowest value in a range, such as the smallest score or cheapest price.
Syntax
=MIN(...)Step-by-step explanation
- 1Choose the numeric range where you want the highest or lowest value.
- 2Enter MIN in a blank cell and select the full range.
- 3Press Enter to check that Excel returns the smallest value.
Common mistakes
Including labels instead of values
Using MAX by mistake
Selecting a range that misses the real minimum
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=MIN(A1:B2)
Result
42
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =MIN(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 42.
Practice area
Use MIN when you need the smallest value from a list of marks, sales, or expenses.
Match against the syntax block above.