MAX Formula Generator (2026) — Find Largest Value | Free Excel & Sheets

Returns the largest value in a set of values.

Generated Formula
=MAX(range)

Learning Resources

Want to master Excel? Check out this Top-Rated Course.

Common Errors & Fixes

  • MAX returns 0 when I expect a positive number

    Causes:
    • The range includes cells with 0 or empty cells that Excel treats as 0.
    • The range contains all text values instead of numbers.
    Fixes:
    • Exclude zero cells with MAXIFS or an array formula.
    • Ensure values are stored as numbers, not text.

Frequently Asked Questions

What is the difference between MAX and MAXA?

MAX ignores text and logical values. MAXA evaluates TRUE as 1, FALSE as 0, and includes text values.

How do I find the MAX while ignoring errors?

Use IFERROR inside an array: =MAX(IFERROR(A1:A10, "")) entered with Ctrl+Shift+Enter, or =AGGREGATE(4, 6, A1:A10) in Excel 2010+.

Does MAX work in Google Sheets?

Yes, MAX works identically in Google Sheets with the same syntax.

Related Formulas

SUMIFCOUNTIFPMTSUMIFSCOUNTIFS

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More