How to use MIN function in Microsoft Excel

In this article, we will learn how to use MIN function in Microsoft Excel.

In Microsoft Excel, MIN function returns the smallest or minimum value from the provided numbers, named range or array.

Let’s take examples and understand:-

Here, we have a table with 5 different examples.

1st Example:-

In this example, we have a range of numbers from which we want to return minimum value.

Follow the steps below given:-

• Enter the function in cell A14
• =MIN(A8:A12)
• Press Enter

• The function will return 1, which is the minimum value within the range

2nd Example:-

In this example, we will see what happens when we take any range in the 1st argument and enter any value in the 2nd argument.

Follow the steps given below:-

• Enter the function in cell B14
• =MIN(B8:B12,2,3-2)
• Press Enter

Formula Explanation:-

In this formula, first we have selected the range from B8:B12 and then we have entered 3-2 which is equivalent to 1, so our minimum value is 1.

3rd Example:-

In this example, we will see what happens when we have blank cells within the range.

Follow the steps given below:-

• Enter the function in cell C14
• =MIN(C8:C12)
• Press Enter

Function has returned 2 as the minimum value. Therefore, we can say that function will look for the minimum value in available values only.

4th Example:-

In this example, we will see what happens when we have text value in the range for which we want to return minimum value.

Follow the steps given below:-

• Enter the function in cell D14
• =MIN(D8:D12)
• Press Enter

The function has returned 4. This means while calculating, MIN function ignores text values as well.

5th Example:-

In this example, we have taken error value in the range for which we are going to calculate minimum value.

Follow the steps given below:-

• Enter the function in cell E14
• =MIN(E8:E12)
• Press Enter

It is because it cannot have any error value in the range which we are referring to in the number argument and hence it returns an error as an answer.

So, this is how MIN function works and we can make use of it in different situations.

Video: How to use MIN function in Microsoft Excel

Watch the steps in this short video, and the written instructions are above the video

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.