# MIN

The `MIN` formula is a statistical function that returns the smallest value in a set of numbers. It is commonly used to find the minimum value from a range of cells or a list of values.

## Usage

Use the `MIN` formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:

Parameters:
1. value1 (required):
The first value or range of cells to evaluate.
2. value2, ... (optional):
Additional values or ranges of cells to evaluate.

## Examples

Here are a few example use cases that explain how to use the `MIN` formula in Google Sheets.

### Find the smallest value in a range

You can use the `MIN` formula to find the smallest value in a range of cells. For example, if you have a list of grades for a test, you can use `MIN` to find the lowest grade.

### Find the earliest date in a range

If you have a list of dates, you can use `MIN` to find the earliest date. This is useful for calculating the age of an item or the time between two events.

### Calculate the minimum value based on criteria

You can use the `MIN` formula with the `IF` formula to calculate the minimum value based on certain criteria. For example, you can find the lowest price for a specific product.

## Common Mistakes

`MIN` not working? Here are some common mistakes people make when using the `MIN` Google Sheets Formula:

### Not providing any values

If you don't provide any values, MIN will return an error. Make sure to provide at least one value.

### Providing non-numeric values

MIN can only find the minimum value in a range of numbers. If you provide non-numeric values, MIN will return an error. Make sure to only provide numeric values.

### Using a range that includes empty cells

If your range includes empty cells, MIN will return 0. To avoid this, make sure to only include cells with values in your range.

### Using a range that includes text

If your range includes text, MIN will return an error. Make sure to only include numeric values in your range.

### Using a range that includes logical values

If your range includes logical values (TRUE or FALSE), MIN will treat them as 1 or 0 respectively. This might not be what you want, so make sure to only include numeric values in your range.

The following functions are similar to `MIN` or are often used with it in a formula:

• `MAX`

The `MAX` function returns the maximum value from a range of cells or a set of supplied values. It is commonly used to find the largest value in a dataset.

• `AVERAGE`

The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

• `SUM`

The `SUM` function in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells.

• `COUNT`

The `COUNT` formula returns the number of numeric values within a specified range of cells. It is commonly used to count the number of entries in a given range that meet specific criteria, such as counting the number of sales above a certain threshold.

• `IF`

The `IF` formula is a logical function used to test a condition and return one value if the condition is true and another value if the condition is false. It is commonly used to create conditional statements and perform calculations based on certain conditions.

You can learn more about the `MIN` Google Sheets function on Google Support.