Master the Excel MAX and MIN functions with easy examples. Learn how to find the highest and lowest values in your data using simple Excel formulas.
Returns the largest value in a set of values.
Syntax
MAX(number1, [number2], ...)
The MAX function syntax has the following arguments: Number1, number2, … Number1 is required, subsequent numbers are optional. 1 to 255 numbers for which you want to find the maximum value.
Returns the smallest number in a set of values.
Syntax
MIN(number1, [number2], ...)
The MIN function syntax has the following arguments: Number1, number2, … Number1 is optional, subsequent numbers are optional. 1 to 255 numbers for which you want to find the minimum value.
further reading:
Exercise 3:
=MAX(A1:A10)The result, 100, should appear in cell A11.
Exercise 4:
=MIN(A1:A10)The result, 10, should appear in cell A11.
Exercise : Find the highest value in the following range of cells:
range: A1:A5
values:
10
20
30
40
50
Exercise : Find the highest value in the following range of cells, ignoring empty cells and text values:
A1:A5
10
Apple
Bananas
30
50
Exercise : Find the minimum value in the following range of cells:
A1:A10 = {10, 20, 30, 40, 50, 60, 70, 80, 90, 100}
Excercise : Find the minimum value in the following range, but only include the values that are in the column B:
| A | B |
|---|---|
| 1 | 2 |
| 3 | 4 |
| 5 | 6 |
| 7 | 8 |
| 9 | 10 |