Skip to content
# EXCEL FUNCTION – MIN

# Excel Function MIN

### MIN Formula in Excel

**Syntax:**

**Syntax Description:**

### How to Use MIN Function in Excel?

The MIN function in Excel is very easy to use. Let us understand the working of the MIN function in some examples.

#### Example 1:

### EXAMPLE 2:-

The Excel function ignores empty value cells and result is 25. But MINA Value will be 1 as shown above.

## EXAMPLE 3:-

if we provide a logical value, the function will ignore it and will give the same result, but MINA will consider it, as shown above:

**Things to Remember:**

### Recommended Articles

## Similar Posts

### EXCEL FUNCTION – AVERAGE

### Excel Function Replace

### EXCEL FUNCTION – DATEVALUE

### EXCEL FUNCTION – MAX

### TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?

### EXCEL FUNCTION – COLUMN

**MIN **function is used to get the smallest number in range or list of values.

Applying the MIN function formula =MIN( give you the minimum value among the Selected cell range.

Below is the MIN formula in Excel.

=MIN(number1,[number2],...)

**number1 **argument is required argument where we can give range or value

**[number2] **argument is optional argument where we can give another range or value

**…** refers that, we can add multiple range or values by separating them with comma ( , )

- Will calculate the lowest marks of students by using MIN formula.

As we can see by applying the formula we got the Minimum score. The result is 25.

– Function will only consider numeric values while evaluating the smallest value

– Multiple ranges can be applied in function by separating them with a comma (,)

– Text/ Spaces will be ignored by the function

– If No values in the range or list of values (i.e. number argument) then the output will return as 0 (zero)

Hope you learned this Function,

Don’t forget to leave your valuable comments!

AVERAGE function is used to get the average of numbers. Function applies formula i.e. average = Sum of all values / (Divided by) number of items.

Excel Function REPLACE REPLACE function is used to replace the existing text from a specific location in a cell to New Text. REPLACE Function has argument four arguments i.e. old_text, start_num, num_chars and new_text. We need to give the…

How to Change TEXT into DATE Format Microsoft Excel “DATEVALUE” is the very useful where dates are available as TEXT and need to convert them to proper DATE format. DATEVALUE function helps to convert the…

MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1

You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use…

COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.