What is MAX?
Returns the largest value in a range. Critical for finding peak values, high scores, and maximum thresholds.
Syntax
=MAX(number1, [number2], ...)
Example
Formula: =MAX(C1:C5)
Result: 95
How It Works
Finds the highest value in the range C1:C5. If the values are 85, 92, 78, 95, 88, the maximum is 95. MAX ignores text and logical values.