top of page

You are learning Functions and Formulas in MS Excel

How can I find the minimum or maximum value with MIN and MAX?

Here's how to find the minimum or maximum value with the MIN and MAX functions in Excel:

Using MIN:

1. Click on the cell where you want the minimum value to be displayed.
2. Type the formula: `=MIN(range)`. Replace "range" with the actual cell range containing the numbers you want to find the minimum for.
- You can enter the cell range directly (e.g., `=MIN(A1:A10)`) or select the range with your mouse.
3. Press Enter: Excel will calculate the minimum value within the specified range and display it in the cell.

Using MAX:

The process for finding the maximum value is very similar:

1. Click on the cell where you want the maximum value to be displayed.
2. Type the formula: `=MAX(range)`. Replace "range" with the cell range containing the numbers you want to find the maximum for.
3. Press Enter: Excel will calculate the maximum value within the range and display it in the cell.

Examples:

* To find the minimum value in cells B2 to B15, you would use the formula `=MIN(B2:B15)`.
* To find the maximum value in cells C3:F3, you would use the formula `=MAX(C3:F3)`.

Additional Notes:

* Both MIN and MAX can handle numbers, dates, and text strings (depending on the desired outcome).
* For text strings, MIN and MAX will return the cell that comes first alphabetically.
* You can use these functions with other calculations. For example, `=MIN(A1:A10)+10` would find the minimum value and then add 10 to it.

bottom of page