# MIN

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.

## 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

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.

## 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 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)

## Questions

**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

MAX

AVERAGE

SUM

COUNT

MEDIAN

SMALL

LARGE