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

## More Information on Excel MIN Function

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

## Sample File

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

## Leave A Comment