ExcelHeroThe MIN function
Returns the smallest number.
How to write it
=MIN(number1, [number2], …)- number1
- A number, cell or range.
💡 Combine with MAX to get the spread: =MAX(r)-MIN(r).
Try it
What is the lowest score?
A
B
1
Student
Score
2
Aisha
88
3
Ben
54
4
Chloe
97
5
Dev
71
6
Emma
63
7
Finn
79
8
Lowest
The smallest number in a range is the MIN.