The MIN function in Google Sheets is useful when you need to return the minimum value in a numeric dataset.
The minimum value is the result of comparing numbers in a specific dataset and finding the number that all other numbers in the dataset are greater than or equal to.
The rules for using the
MIN function in Google Sheets are as follows:
- The function requires at least one argument, which may be a value, cell, or cell range.
- The function then outputs the minimum value out of the arguments provided.
Let’s take a look at an example of where we can use the
Let’s say you’re shopping for a new phone. You have a list of potential choices available, as well as discounts available on those platforms. Given the discounted prices, which phone is the cheapest option?
MIN function, we can easily find the choice that will cost us the least amount of money.
MIN function is useful for cases where you need to find the smallest value in a list. Later, we’ll go through how we can use the data provided and the
MIN function to return the result we need. For now, let’s look into how the
MIN function works.
The Anatomy of the MIN Function
The syntax of the
MIN function is as follows:
=MIN(value1, [value2, ...])
Let’s take apart this formula and understand what each of these terms means:
- = the equal sign is how we start any function in Google Sheets.
- MIN() is our
MINfunction. It returns the minimum value in a numeric dataset.
- value1 refers to the first value or range to consider when computing the minimum value.
- value2 refers to additional values or ranges to consider when finding the minimum value.
- Text values found in the arguments will cause it to return a
A Real Example of Using MIN Function
Let’s look at a real example of the
MIN function being used in a Google Sheets spreadsheet.
In the table below, we have our list of cell phone options along with their computed discount price. Using the
MIN function, we were able to find out that the cheapest option is worth $600.
To get the value seen in cell B10, we just need to use the following formula:
MIN function only returns the value, so we manually checked which option corresponds to the minimum price. If you want to get this using a formula, we can use the
To get the cheapest option on our list, we can use the following formula:
Let’s quickly break this down. The
INDEX function requires three arguments: a range, a row offset, and a column offset. Since we want
INDEX to return the name of a phone, we’ll use A2:A8 as our range. The column offset remains 0 since we only need to look at one row for now.
MATCH function returns the relative position of an item in a range that matches a specified value. In this formula, we’re finding the cell that matches the smallest value in the E2:E8 range (which we find using the
MIN formula). In this case, the
MATCH function returns 6 since $600 can be found in the 6th place of the given range. An offset of 6 in range A2:A8 gives us the Xiaomi phone.
You can make your own copy of the spreadsheet above using the link attached below.
If you’re ready to try out the
MIN function in Google Sheets, let’s begin writing it ourselves!
How to Use MIN Function in Google Sheets
In this section, we will go through each step needed to start using the
MIN function in Google Sheets. This guide will show you how to find the cheapest item in a list, as seen in the previous examples.
Follow these steps to start using the
- First, select the cell which will hold the result of our
- Next, we just have to type the equal sign ‘=‘ to begin the function, followed by ‘MIN(‘.
- You may find a tooltip box with tips on how to use the current function. Click on the arrow found in the top-right-hand corner of the box to hide it from view.
- Next, we’ll select the range of values to find the minimum value. In this case, we’ll be looking for the minimum value in the range E2:E8.
Afterward, we can simply hit Enter to let the function evaluate. We can also get the name of the phone using the
MATCHformula mentioned in the previous section.
Frequently Asked Questions (FAQ)
- When should I use the MIN and MINA functions?
The main difference is that the
MINAevaluates TRUE and FALSE values as 1 and 0, respectively. The
MINfunction only considers numeric values when finding the result. If your dataset contains logical values, then it is suggested to use the
- Will non-numeric values return an error?
MINfunction will just ignore all non-numeric values in the provided dataset. If no numeric values are found in the arguments, the
MINfunction will simply return 0.
That’s all you need to remember to start using the
MIN function in Google Sheets. This guide shows how simple it is to use the
MIN function to find the largest value in a dataset.
The MIN function is just one example of a mathematical function in Google Sheets. With so many other Google Sheets functions out there, you can surely find one that best suits your worksheet.
Make sure to subscribe to our newsletter to be the first to know about the latest Google Sheets guides and tutorials from us.