Better Sheets

How to Use MIN() in Google Sheets

Description

Returns the minimum value in a numeric dataset.

How To Actually Use MIN() in Sheets

MIN(value1, [value2, ...])

Try MIN yourself

Use the MIN formula to find the smallest number in the range A1:A10. Your formula should return the minimum value from this dataset.

Your formula

Hints (3)

Locale Separator ,

Official Docs

3 Better Sheets Tutorials

Use Min and Max for More Average Averages

What happens very often is we want to figure out an average averages, help us tell the story of a large set of data, but averages also can lie.

Beginner

AVERAGE() MAX() MEDIAN() MIN()

Secure Your Sheets by BetterSheets.co

tactics on how to keep your sheets secure.

Beginner

ARRAYFORMULA() FILTER() INDEX() MATCH() MIN()

Create a Summary Tab with Min and Max

Free tutorial for finding Minimum and Maximum data points.

Intermediate

INDEX() MAX() MIN()

Transcript-matched member videos for MIN(). Click through to watch.

Browse more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Unlock these tutorials

Learn more about the MIN() formula:

Generate a MIN() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses MIN(). 2 free AI generations, no signup. Members get unlimited use.

Generate a MIN() formula

How to Use MIN() in Google Sheets

Try MIN yourself

Use Min and Max for More Average Averages

Secure Your Sheets by BetterSheets.co

Create a Summary Tab with Min and Max

More related tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Calculate ROAS in Google Sheets

Write Apps Script to Create a New Google Sheets Formula

Google Sheet Basics - The Absolute Basics