# How to Use Excel MIN Function (Examples + Video)

## Excel MIN Function (Example + Video) ### When to use Excel MIN Function

MIN function can be used when you want to get the smallest value from a set of values.

### What it Returns

It returns the smallest value from a set of values.

### Syntax

=MIN(number1, [number2], …)

### Input Arguments

• number1 – the first number from a set of values from which you want to get the minimum value.
• [number2], .. – (optional) second number from a set of values from which you want to get the minimum value. Up to 255 arguments can be used in the MIN function.

• Empty cells, logical values, or text in the array or reference are ignored.
• Arguments that are error values or text that cannot be translated into numbers cause errors.
• Arguments can either be numbers or names, arrays, or references that contain numbers.
• Logical values and text representations of numbers that you type directly into the list of arguments are counted.
• If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored.
• If the arguments contain no numbers, MIN returns 0 (zero).

## Excel MIN Function – Video Tutorial

Related Excel Functions: FREE EXCEL BOOK