# Quick Intro

Use Excel MIN Function to get the smallest value from a specified set of values.

In simple words, It will return the smallest value from a set of numbers given. For example, from 10, 20, 25, 30 it will return 10 in the result as 10 is the smallest value from the given set of values.

## Syntax

MIN(number1, [number2], …)

• number1 A number, a cell which has a number or a range of cells having numbers from which you want to get the smallest number.
• [number2] A number, a cell which has a number or a range of cells having numbers from which you want to get the smallest number.

• You can refer to a single cell, a named range, a range of cells or an array.
• If there are no numbers in specified arguments it will return 0.
• If there is text or an error value in the argument, it will return #N/A.
• If you directly enter a logical value or a text which represents a number into the function, that will be counted.
• It will only consider numeric values. Empty cells, text & logical values in a reference or in an array will be ignored.
• The maximum number of arguments you can refer is 255.

## Examples

In the below example, I have entered numbers directly into the function by separating them using a comma. You can also enter a number by using double quotation marks. It will consider them as a number.

In the below example, I have refers to a range and it has return 1861 in the result as the largest value. You can also refer to an array as well.

In the below example, I have encountered with an error value & function has returned an error value in the result.

## What’s Next?

To learn more about Excel MIN Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have MAX function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.