Excel MIN MAX Function

What this does

MAX returns the largest numeric value among its arguments. Text, logical values and blanks are skipped rather than compared, which means a column of numbers stored as text returns 0 — a wrong answer that looks like a real one. A second use worth knowing is as a floor: =MAX(0, A2-B2) clamps a difference so it never goes negative, which is far shorter than the equivalent IF. For the largest value meeting a condition, use MAXIFS; for the second or third largest, use LARGE. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. For “excel min max function”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected formula change, and only then apply the same setup to the full sheet. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. That is what makes a calculation you can defend to a CFO or an auditor useful in real work: repeatable, auditable, and not dependent on memory or luck.

A worked example

Daily traffic in B2:B400: =MAX(B2:B400) returns the peak day. Clamping a shortfall so it cannot go below zero: =MAX(0, Target-Actual). Finding the later of two dates, which are just numbers underneath: =MAX(A2, B2), formatted as a date. MAX is both the peak-finder and the standard way to clamp a value at a floor, which is why it shows up far outside pure statistics. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.

In Google Sheets

Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Treat “excel min max function” as a small building block rather than a chore. Once the inputs sit in their own cells and the formula reads from them, the same setup answers a dozen related questions with a tweak, and Excel keeps every dependent figure current as the data changes. The tool above is there so you can rehearse and verify before committing anything to a real workbook; the steps and worked example are there so the logic sticks. Get it right once and it stops costing you time — it starts saving it, every time the question comes back around.

Common mistakes

• Numbers stored as text, which MAX ignores — returning 0 or an unexpectedly small value.
• Using MAX where a condition applies; MAXIFS handles "largest in the West" directly.
• Wanting the second-largest and reaching for MAX on a trimmed range instead of LARGE with k=2.

Frequently asked questions