How To Use MIN Function in Google Sheets

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.

Step 1

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.

Step 2

Type the formula “=MIN(“ to start the MIN function in Google Sheets.

Step 3

Enter the cell range you want to search the minimum value for as the sole argument of the function.

Step 4

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.

Step 5

We can also provide two or more separate cell ranges as arguments for the MIN function.

Summary

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.