Last Updated on November 1, 2023 by Jake Sheridan
In this tutorial, you will learn how to use the MIN function in Google Sheets.
How To Use MIN Function in Google Sheets
The MIN function in Google Sheets is helpful if you want to quickly find the smallest value in a a range or dataset.
You can either provide several values as arguments to the MAX function or provide one or more cell ranges as arguments.
For example, suppose you have a list of participants for a survey.
Since you must follow a rule that all participants must be at least 18 years of age, you want to find out whether there are any participants who are below the age limit. You can use the MIN function on the age field to find the age of the youngest participant.
In this guide, we’ll explain how to use the MIN function in Google Sheets.
How To Find the Smallest Value in a Range in Google Sheets
Here’s how to use the MIN function to find the smallest or minimum value in a range in Google Sheets.
First, select a blank cell where you want to place the MIN function.
In this example, we want to search the range A2:A16 for the minimum value and output the result in cell D1.
Type the formula “=MIN(“ to start the MIN function in Google Sheets.
Enter the cell range you want to search the minimum value for as the sole argument of the function.
Hit the Enter key to evaluate the MIN function.
In this example, we’ve determined that the lowest value present in column A is 1150.
We can also provide two or more separate cell ranges as arguments for the MIN function.
This guide should be everything you need to use the MIN function to find the smallest value in a given range.
You may make a copy of this example spreadsheet to test it out on your own.
More basic math formulas in Google Sheets:
- AVERAGE Function
- MAX Function
- FLATTEN Function
- GROWTH Function
- Transpose Data
- SORT Function
- How To Round
- How To Multiply
- How To Divide
- How To Subtract
- Round Down
- Add Cells
- Multiply Cells
- Subtract Cells
- Find Median
- Find Quartiles
- Automatically Add Numbers
- Find Mean
- Standard Deviation
- Find Average
- Find Range
- Find Variance
- T Test
- Use Pi In Google Sheets
- How To Square
- Square Root
- Sum Columns or Rows
- SUMPRODUCT Formula
- How To Create A Function
- How To Create Formula