Formulas > =MIN()

# How To Use MIN() Function in Google Sheets

Description

Returns the minimum value in a numeric dataset.

What does the MIN formula do?
What are the arguments of the MIN formula?
How does the MIN formula handle different data types?
Can the MIN formula be used with empty cells or cells containing text?
Can the MIN formula handle a range of cells as input?
What happens if there are cells with errors in the range?
How does the MIN formula treat negative numbers?
The MIN formula in Google Sheets is used to find the minimum value within a range of cells or a list of values. It returns the smallest number from the given inputs.

To use the MIN formula appropriately, follow these steps:

Write "MIN" followed by an opening parenthesis.
Specify the range of cells or values from which you want to find the minimum, separated by commas.
Close the parenthesis.
Press Enter to get the result.
For example, to find the minimum value in cells A1 to A10, you would write "=MIN(A1:A10)".

The MIN formula can be mistyped in the following common ways:
Misspelling the function name as "MIM" or "MN" instead of "MIN".
Omitting the opening or closing parenthesis.
Not providing the correct arguments or separating them with incorrect commas.

Some common inappropriate uses of the MIN formula include:
Applying the formula to non-numeric values or cells containing text.
Using the formula with cells that have errors, as it will return an error result.
Neglecting to consider the context of the data and using the MIN formula when another formula or approach might be more suitable.

Common pitfalls when using the MIN formula include:
Forgetting to update the range or values referenced by the formula when copying or dragging it to other cells.
Mixing up the order of the arguments, which can lead to incorrect results.
Using the MIN formula in situations where it is unnecessary, leading to unnecessarily complex or inefficient calculations.

Common mistakes when using the MIN formula include:
Including empty cells in the range, which can result in an unintended minimum value.
Using the MIN formula with non-adjacent cells without specifying a range correctly.
Using the MIN formula with ranges that include cells containing errors without accounting for them.

A common misconception people might have with the MIN formula is that it can automatically ignore non-numeric values or errors. However, the MIN formula will return an error if any of the cells contain errors, and it will treat non-numeric values as the minimum if they are present in the range.

Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK().

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

Looking for a way to segment data based on specific criteria? The FILTER formula is perfect for you.

If you need to replace VLOOKUP, give INDEX/MATCH a try.

At bettersheets.co/formulas, I have everything you need to take your Google Sheets skills to the next level.
From ARRAYFORMULA() to ZTEST(), Better Sheets has it all.

How To Actually Use MIN() in Sheets

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

3Better Sheets Tutorials

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.
tactics on how to keep your sheets secure.
Free tutorial for finding Minimum and Maximum data points.

Min & Max, Small & Large

Discover basic statistical functions: min, max, small, and large. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!

Generate a MIN() formula for your needs with AI

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.

Asa

Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.

Better Sheets