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.

image 1

 

Let’s take examples and understand:-

Here, we have a table with 5 different examples.

image 2

 

1st Example:-

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

image 3

 

Follow the steps below given:-

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

image 4

 

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

image 5

 

Follow the steps given below:-

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

image 6

 

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.

image 7

 

Follow the steps given below:-

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

image 8

 

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.

image 9

 

Follow the steps given below:-

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

image 10

 

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.

image 11

 

Follow the steps given below:-

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

image 12

 

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.

 

image 48

 

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



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>