ExcelHeroThe MAX function
Returns the largest number.
How to write it
=MAX(number1, [number2], …)- number1
- A number, cell or range.
💡 To find who has the max, use INDEX and MATCH with MAX.
Try it
What is the best 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
Best
The highest number in a range is the MAX.