Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Find Number Closest To Zero

1. I agreed to these rules
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

Excel Video Tutorials / Excel Dashboards Reports

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

Excel Video Tutorials / Excel Dashboards Reports

3. I agreed to these rules
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. ## 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

Excel Video Tutorials / Excel Dashboards Reports

5. I agreed to these rules
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

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

#### 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