How to use MIN formula in Google Sheets

The MIN function in Google Sheets helps you find the smallest number in a set of values, whether it’s from a range, individual numbers, or multiple ranges. It’s especially useful for quickly identifying the lowest value in datasets such as prices, scores, or measurements.

How It Works

• The MIN function returns the smallest number from the specified range or set of values.
• It ignores text, empty cells, and logical values.
• If only one number is given, that value is returned as the minimum.

Syntax and Examples of the MIN Formula

Use the below Google Sheets MIN formula:

=MIN(value1, [value2,])

• value1: The first number, cell reference, or range to evaluate.
• [value2,]: Optional additional numbers, cell references, or ranges.

Examples:

1. Basic Example:
To find the smallest number in the range A1 to A10:

=MIN(A1:A10)

2. Using Multiple Ranges:
To evaluate two separate ranges (A1:A10 and B1:B10):

=MIN(A1:A10, B1:B10)

3. Ignoring Non-Numeric Values:
If the range includes text or empty cells, the MIN function skips them and calculates only numeric values.

These examples show how the MIN formula simplifies data organization in Google Sheets.

1. How to Use MIN Formula in Google Sheets

The MIN formula is a powerful tool for finding the smallest value in a dataset, often used as a lowest price finder or for data organization in Google Sheets. Here’s a simple MIN function example to guide you:

Step 1: Select a Cell

Click on the cell where you want the result (minimum value) to appear.

Step 2: Enter the Formula

Type the following formula:

=MIN(A1:A10)

For example, =MIN(A1:A10) to find the smallest value in the range A1 to A10.

Step 3: Press Enter

Press Enter. The smallest value in the specified range will be displayed in the selected cell.

2. Troubleshooting Common MIN Function Errors

1. Error: #VALUE!

• Cause: Non-numeric values in the referenced range.
• Solution: Ensure the range contains only numeric values. Non-numeric entries are ignored but won’t cause the error unless the formula or range is incorrect.

2. Error: No Numeric Values Found

• Cause: The range does not contain any numbers.
• Solution: Double-check the range to include valid numeric values. If the range has no numbers, the MIN function returns 0.

3. Incorrect Results

• Cause: Hidden rows or filtered data can affect the calculation.
• Solution: Verify the range includes all relevant data. Use visible-only formulas if necessary (e.g., SUBTOTAL with filters).

4. Empty Range

• Cause: The range is blank or incorrectly referenced.
• Solution: Check for typos or ensure the correct range is selected.

These tips help address common issues when using the MIN function in Google Sheets.