MIN
The MIN function finds the smallest value in a set of values. It's used to determine the minimum numerical value within a range of cells or an array.
Syntax 🔗
=MIN(number1
, [number2
, ...])
number1 | The first number or range of numbers for which you want to find the minimum value. |
number2 (Optional) | Additional numbers or ranges of numbers for which you want to find the minimum value. You can include up to 255 numbers in total. |
About MIN 🔗
Use the MIN function in Excel to find the smallest value in a set of numbers. This function provides a simple way to identify the minimum numeric value within a range or across multiple ranges, helping you make quick and accurate decisions in your data analysis.
Examples 🔗
Suppose you have a range of numbers in cells A1 to A5: 20, 15, 30, 10, 25. To find the smallest number in this range, you can use the MIN function like this: =MIN(A1:A5)
If you have individual numbers to compare, such as 45, 60, 30, 25, and 50, you can input them into the MIN function as follows: =MIN(45, 60, 30, 25, 50)
Notes 🔗
The MIN function considers only numerical values, ignoring non-numeric entries in the specified range. Make sure your arguments are valid numerical entries to achieve correct results with the MIN function.
Questions 🔗
Yes, the MIN function can process both individual numbers and ranges of cells. You can mix and match these inputs within the function to find the smallest value across a varied dataset.
What happens if I have non-numeric values within the range provided to the MIN function?The MIN function automatically filters out any non-numeric values within the given range and focuses solely on numerical entries. It disregards text or empty cells to provide an accurate minimum value calculation.
Is there a limit to the number of values I can input into the MIN function?You can include up to 255 individual numbers or ranges of numbers within the MIN function. Excel allows for a robust comparison of a significant quantity of values to identify the smallest among the lot.