Are you tired of manually searching for the smallest value in your Google Sheets? Look no further! In this article, we’ll show you how to use the powerful MIN function in Google Sheets to quickly identify the minimum value in a range of numbers. Get ready to take your spreadsheet game to the next level!
Using the MIN Formula in Google Sheets
Let’s dive right in and explore how to use the MIN formula in Google Sheets. Follow these simple steps:
- Type “=MIN” or navigate to “Insert” → “Function” → “MIN” in your Google Sheets.
- Select the range from which you want to find the smallest number.
The generic formula looks like this:
- Value 1: This can be a single number, a cell reference, or a range of cells.
Ready for some examples? Let’s dive in!
Example 1: Finding the Lowest Total Score
Imagine your company is preparing for a new product launch, and you’re conducting quality tests for different product types (A to F). You want to find the lowest score from a list of quality test scores (Test A, Test B, and Test C).
In this example, the selected range includes the total scores for all types: 21, 24, 27, 30, 33, 36, with the lowest score being 21.
Example 2: Finding the Lowest Individual Test Score for Type A
Now, let’s focus on the individual test scores for Type A. The selected range contains the results of Type A tests for each test: 7, 1, 13. By using the MIN formula, we determine that the lowest score is 1.
Example 3: Finding the Lowest Score for Test A
In this scenario, we select the scores of Test A for all types. The range in the formula consists of 7, 8, 9, 10, 11, 12, with the lowest score being 7.
Example 4: Finding the Lowest Individual Score for Tests A and C
Here’s an interesting twist! You can select non-adjacent fields, as shown in this example. Each field (as a “Value”) should be separated by a comma. The result is a lowest score of 7.
Example 5: Finding the Lowest Individual Score for All Tests
If you want to find the lowest score across all tests, you can select the entire range. However, make sure the chosen range does not contain irrelevant numbers. In the above example, the lowest score is 1 for all the tests.
Example 6: Manual Input Example
While we always recommend using cell references, we understand that sometimes you may want to manually enter a series of numbers in a formula to find the lowest among them. In this case, you can input each number (as a “Value”) separated by commas.
Looking for the Highest Value in Google Sheets?
But wait, what if you need to find the highest value instead? Don’t worry, we’ve got you covered! You can utilize the MAX function in Google Sheets to find the highest value within a selected range. Check out this page to learn how to use the MAX formula in Google Sheets.
Now that you’ve learned how to use the MIN function in Google Sheets, it’s time to supercharge your data analysis and make your spreadsheets work for you!
Article originally published on Crawlan.com.
