Formulas > =MIN()
How To Use MIN() Function in Google Sheets
Description
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.
Hints (3)
-
Remember to select the correct range of cells.
-
The MIN function takes one or more arguments.
-
Check for any non-numeric values in your range.
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.
AVERAGE()
MAX()
MEDIAN()
MIN()
Secure Your Sheets by BetterSheets.co
tactics on how to keep your sheets secure.
ARRAYFORMULA()
FILTER()
INDEX()
MATCH()
MIN()
Create a Summary Tab with Min and Max
Free tutorial for finding Minimum and Maximum data points.
INDEX()
MAX()
MIN()
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