MIN
Returns the smallest value from a range.
=MIN(B2:B11)
Example:
Marks: 75, 82, 68, 91, 55
Minimum = 55
MAX
Returns the largest value from a range.
=MAX(B2:B11)
Maximum = 91
Real-World Uses
|
Function |
Use |
|
MIN |
Lowest marks |
|
MAX |
Highest marks |
|
MIN |
Lowest expense |
|
MAX |
Highest sales |
Practice
Calculate the lowest and highest marks from a 10-student marks sheet.