Find the minimum positive value in Microsoft Excel

In this article, we are going to learn how to find the minimum positive value in a range in Microsoft Excel. To return the positive minimum value from the data, we will use Min function along with IF function.

Why we will use Min function along with IF function?

Minimum function will help to find out the minimum number in the range. And ‘if function’ will help to pick the positive value from a range.

Let’s take an Example and understand.

We have a student list in the sheet in which we have scores, and the scores can be negative also, so we want to return minimum value from the positive values.

 

image 1

 

Follow below steps to find out the minimum positive number in the range:-

  • Enter the formula in cell C2.
  • =MIN(IF((B2:B11>0)*(B2:B11),(B2:B11)))
  • Press Ctrl+Shift+Enter.
  • The formula is an Array Formula, after entering the formula in the cell, press F2 and then press Ctrl+Shift+Enter.

image 2

In Excel, we can use the combination of functions to get any kind of result. Excel has  ability to save our time.

image 29

 

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

 

Users are saying about us...

  1. “the following sums next 7 columns on the right
    ActiveCell.FormulaR1C1 = “”=SUM(RC[1]:RC[7])””

    How do I sum next N columns on the right?
    dim N=9
    ActiveCell.FormulaR1C1 = “”=SUM(RC[1]:RC[&N&])”” ‘will not work “

  2. “When you declare the variable, you need to state what it is, not its value:

    To keep it simple, try this:

    Sub Alan()

    Dim N As Integer

    N = 9

    ActiveCell.FormulaR1C1 = “”=SUM(RC[1]:RC["" & N & ""])””

    End Sub

    Note that this will write over whatever was already in the active cell as written!

    Hope that works, “

  3. “the following sums next 7 columns on the right
    ActiveCell.FormulaR1C1 = “”=SUM(RC[1]:RC[7])””

    How do I sum next N columns on the right?
    dim N=9
    ActiveCell.FormulaR1C1 = “”=SUM(RC[1]:RC[&N&])”” ‘will not work “

  4. “When you declare the variable, you need to state what it is, not its value:

    To keep it simple, try this:

    Sub Alan()

    Dim N As Integer

    N = 9

    ActiveCell.FormulaR1C1 = “”=SUM(RC[1]:RC["" & N & ""])””

    End Sub

    Note that this will write over whatever was already in the active cell as written!

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>

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube