Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Find Number Closest To Zero

  1. #1
    Join Date
    3rd February 2008
    Posts
    3

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    23rd October 2003
    Location
    France Alsace
    Posts
    3,697

    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

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    3rd February 2008
    Posts
    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 )

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    23rd October 2003
    Location
    France Alsace
    Posts
    3,697

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    3rd February 2008
    Posts
    3

    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.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Display Closest Number Match
    By dakke in forum EXCEL HELP
    Replies: 1
    Last Post: February 15th, 2008, 13:53
  2. Return Row Number Of Closest Date
    By abbani in forum EXCEL HELP
    Replies: 5
    Last Post: January 16th, 2008, 14:14
  3. Check number closest to zero
    By Runes in forum EXCEL HELP
    Replies: 3
    Last Post: November 5th, 2005, 01:43
  4. find closest value
    By stooly in forum EXCEL HELP
    Replies: 2
    Last Post: July 25th, 2005, 16:39
  5. Find the closest date
    By Richnl in forum EXCEL HELP
    Replies: 1
    Last Post: April 11th, 2005, 20:23

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno