MIN Formula Generator (2026) — Find Smallest Value | Free Excel & Sheets

Returns the smallest value in a set of values.

Generated Formula
=MIN(range)

Learning Resources

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

Common Errors & Fixes

  • MIN returns 0 when expecting a positive minimum

    Causes:
    • The range includes zeros which are technically the minimum.
    • Blank cells in the range are counted as 0.
    Fixes:
    • Use MINIFS or array formulas to exclude 0.
    • Use =MINIFS(range, range, ">0") in supported Excel versions.

Frequently Asked Questions

What is the difference between MIN and MINA?

MIN ignores text and logical values. MINA evaluates TRUE as 1 and FALSE as 0, which may give unexpected results.

How do I find the smallest value excluding zeros?

Use an array formula: =MIN(IF(A1:A100>0, A1:A100)), or MINIFS in Excel 2019+ if you have a criteria range.

Does MIN work in Google Sheets?

Yes, MIN 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