How to Use MAX Function in Excel: Syntax and Examples

Use the MAX function in Excel to find the largest number in a range or list of values. Enter =MAX(range) where range is the cells you want to check, and Excel returns the highest value.

Syntax

The MAX function finds the largest number in a set of values or cells.

• MAX(number1, [number2], ...): You can list numbers or cell ranges.
• number1, number2, ... are numbers, cell references, or ranges.
• It returns the highest numeric value among the inputs.

excel

=MAX(number1, [number2], ...)

Example

This example shows how to find the highest score from a list of exam scores in cells A1 to A5.

excel

=MAX(A1:A5)

Output

If A1=78, A2=85, A3=92, A4=88, A5=79, the output is 92

Common Pitfalls

Common mistakes include:

• Using text values inside MAX which are ignored, possibly causing confusion.
• Forgetting to use a range and instead typing numbers separated by commas incorrectly.
• Using MAX on empty cells returns 0, which might not be expected.

excel

Wrong: =MAX(A1, A2, "text")  
Right: =MAX(A1:A3)  (where A1:A3 contain only numbers)

Quick Reference

Tips for using MAX:

• Use ranges like A1:A10 to include many cells easily.
• Combine with other functions like IF for conditional max values.
• Remember MAX ignores empty cells and text.

Key Takeaways

Use =MAX(range) to find the highest number in a group of cells.

MAX ignores text and empty cells, only numbers count.

Always check your range to avoid unexpected zeros or missing values.

You can list numbers or ranges as arguments in MAX.

Combine MAX with other functions for advanced uses.