MIN function

The MIN function in Excel is used to find the smallest number in a range of numbers or a set of values. It helps identify the minimum value from a dataset, making it useful for data analysis, such as finding the lowest sales number, temperature, or test score.

Syntax:

MIN(number1, [number2], ...)

Arguments:

• number1: Required. The first number, cell reference, or range of values to evaluate.
• number2, …: Optional. Additional numbers, cell references, or ranges to evaluate. You can include up to 255 arguments.

Output:

The function returns the smallest number from the provided set of numbers, cells, or ranges.

How It Works:

The MIN function evaluates each value in the provided range or list and returns the smallest one. It ignores non-numeric values (e.g., text) in the evaluation. If all values are non-numeric, it will return an error (#VALUE!).

Example:

1. Example 1: Finding the Minimum in a Range of Cells Suppose you have the following numbers in cells A1 to A5:

   A1: 50
   A2: 30
   A3: 40
   A4: 10
   A5: 20
   

   To find the smallest value in the range A1:A5, use the formula:

   =MIN(A1:A5)
   

   This will return 10, because it is the smallest number in the range.

2. Example 2: Finding the Minimum of Multiple Values If you have the values 15, 25, 5, and 30, use the formula:

   =MIN(15, 25, 5, 30)
   

   This will return 5, which is the smallest value among the numbers.

3. Example 3: Ignoring Non-Numeric Values If you have the following data in cells A1 to A4:

   A1: 10
   A2: "apple"
   A3: 20
   A4: "banana"
   

   Using the formula:

   =MIN(A1:A4)
   

   The MIN function will ignore the text values (“apple” and “banana”) and return 10, as it is the smallest number in the range.

4. Example 4: Handling Empty Cells If you have the following data:

   A1: 25
   A2: 10
   A3: (empty)
   A4: 30
   

   Using the formula:

   =MIN(A1:A4)
   

   The function will ignore the empty cell and return 10, the smallest number.

Key Points:

• The MIN function can handle numbers, cell references, and ranges.
• It ignores non-numeric values and empty cells in the evaluation.
• If there are only non-numeric values in the range, it returns the #VALUE! error.

Use Cases:

• Identifying the lowest value in a dataset, such as minimum sales, temperature, or test scores.
• Financial analysis: Find the lowest price, cost, or return on investment in a set of data.
• Surveys: Determine the lowest rating or score in survey responses.

Notes:

• The MIN function can be combined with other Excel functions like IF or ARRAY functions for more complex analysis.
• If you need to find the maximum value, you can use the MAX function, which works similarly but returns the largest number in the dataset.