The MIN function is used to find the smallest value in a set of values. It is commonly employed in Excel to quickly determine the minimum numerical value within a range of cells or an array.


=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

When on the quest for the smallest of values across a series of numerical entries in Excel, the MIN function stands as your trusty ally. Painted in the vibrant hues of simplicity, this function delivers a straightforward solution for identifying the tiniest numeric morsel within a given set, sparing you the torment of manual scrutiny and comparison of values. Whether your dataset comprises a single range or multiple pockets of numeric treasure, MIN swiftly illuminates the path to the adorably diminutive entity nestled within the mix, ensuring swift and precise decision-making in the realm of numerical analysis in Excel.


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 as follows: =MIN(A1:A5)

If you have individual numbers to compare, such as 45, 60, 30, 25, and 50, you can simply input them into the MIN function like so: =MIN(45, 60, 30, 25, 50)


Can the MIN function handle both individual numbers and ranges of cells?

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.

Related functions