MAX returns the greatest number among its arguments. It scans ranges for numeric values and ignores text and blanks, so a stray label never wins. With no numbers present it returns 0 rather than an error, which makes it safe for dashboards. Use it for peak sales or top score.
Returns a number. Text and blanks in ranges are ignored; no numbers gives 0.
The same range read four ways, measured live. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =MAX(A2:A6) | 92 | Top score |
| =MAX(B2:B6) | 1500 | Peak sales |
| =MAX(A2:A8) | 92 | Blank and text ignored |
| =MAX(10,20,30) | 30 | Direct numbers |
| =MAX(A2:A4) | 92 | First three scores |
| =MAX(0,A2:A6) | 92 | Floor at 0 |
| =MAX(-5,-10) | -5 | Larger of two negatives |
| =MAX(B2:B8) | 1500 | All sales |
Edit the table or type any formula β the engine evaluates instantly. Load a preset to find peaks and compare aggregations.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User β each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
MAX is a core statistical function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
MAX is one piece. The full course walks the toolkit end to end with live, measured examples.