Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Find Number Closest To Zero

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Find Number Closest To Zero

    Hello
    Can someone help me to make a code where I choose the number closest to zero (it has to be above zero and not zero). I have cells from B2 to S81 with number close to zero. But I am actually interested in cells from A2 to A81 for my work so I need a coupling between these cells.
    Cells with connections are: example A2-I2, A13-P13 to A75-C75

    Thank you for your help

  • #2
    Re: Find Number Closest To Zero

    Can you attached a file as example.
    For the closest enter somewhere =MIN(IF(A1:A81>0,A1:A81)) with CONTROL +SHIFT + ENTER
    Triumph without peril brings no glory: Just try

    Comment


    • #3
      Re: Find Number Closest To Zero

      I need something like this http://www.ozgrid.com/forum/showthread.php?t=42000
      but not for a row of numbers but for a square of numbers (sorry for my bad use of word )

      Comment


      • #4
        Re: Find Number Closest To Zero

        It looks like you want to cover several groups of data:
        =MIN(IF(E4:E6>0,(E4:E6)),(IF(E4:E6>0,(E4:E6))))
        You can add many groups in the IF
        Or perhaps a short data example could be useful
        Attached Files
        Triumph without peril brings no glory: Just try

        Comment


        • #5
          Re: Find Number Closest To Zero

          This is only the first step. Now I would need that the cell with the lowest number is not used but the cell that is the first one horizontal in that line to be used.

          Comment

          Trending

          Collapse

          There are no results that meet this criteria.

          Working...
          X