What is the MAX Function
The MAX function returns the largest number in a range or list. It ignores text, blanks, and logical values. MAX is useful for finding peak values, highest scores, and top performance.
Formula: =MAX(number1, [number2], ...)
Practical Example 1
Sales are in B2:B10.
Type: =MAX(B2:B10)
Result: the highest sale value
Practical Example 2
Get the highest mark in a class.
Type: =MAX(C2:C20)
Result: the top score
Practical Example 3
MAX with a condition using MAXIFS.
Type: =MAXIFS(C:C, A:A, Dhaka)
Result: the highest sales in Dhaka
Practical Example 4
Combine MAX with a text label.
Type: =Top sale: & MAX(B2:B10)
Result: a label with the top sale value
When to Use It
MAX is used for finding peak sales, highest scores, maximum temperatures, top performers, and any analysis that needs the largest value in a dataset.