MAX Function in Excel
Beginner
Returns the largest number in a set of values.
Syntax
=MAX(number1, [number2], ...)Example
Use Case
Find the highest score in a test.
Common Errors to Avoid
- Ignores text and logical values
- Hidden rows still included in calculation
- Returns 0 if range contains only text or empty cells
Pro Tips
Use MAXIFS for conditional maximum values. Combine with conditional formatting to highlight the max value. For visible cells only, use SUBTOTAL(104,range).
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →