Google Sheets MIN Function: Syntax, Examples & Tips

value1:
The first number or cell reference that you want to evaluate for the minimum value.

value2:
Additional numbers or cell references that you want to evaluate for the minimum value. This parameter is optional and you can include multiple additional values.

What is a MIN Formula?

The MIN function in Google Sheets is a simple yet effective tool used to find the smallest number in a range of cells. It is particularly useful when you need to analyze data sets and identify the minimum value, whether it's for financial records, test scores, or any numerical data.

In simpler terms, the MIN function allows you to quickly determine the lowest value in a specified range of numbers.

A Practical Example

Imagine you are tracking the sales figures for different products over a month:

Sales Data Table:

You want to find out which product had the lowest sales during the month.

MIN Formula

To achieve this, you would use the MIN function as follows:

=MIN(B2:B5)

In this formula:

• B2:B5 is the range where the function will look for the minimum sales value.

Result of the Formula

When you apply the MIN formula to the Sales Data Table, the output would be:

This indicates that the product with ProductID 102 had the lowest sales at 150.

Why Use MIN?

The MIN function is beneficial because it provides a quick and efficient way to analyze numerical data. It helps you identify the lowest values in your data sets, which can be crucial for making informed business decisions, evaluating performance, and understanding trends.

Key Takeaways:

• MIN: A fundamental Google Sheets function that finds the smallest number in a specified range.
• Simplicity: Easy to use and understand, making it accessible for users of all skill levels.
• Data Analysis: Essential for analyzing sales figures, test scores, or any numerical data where identifying the minimum value is important.
• Common Use Cases: Ideal for financial analysis, performance tracking, and any scenario where understanding the lowest values is necessary.

The MIN function is a vital tool for anyone working with numerical data in Google Sheets, providing a straightforward way to enhance data analysis and reporting capabilities.

Happy spreadsheeting!