Two mathematicians were traveling on a train.

One says to the other: It appears that those sheep have just been shorn.

The other replies: Well, at least on the side facing us.



Biff wrote:

Are you positive that the OP wanted it that way? <vbg

I'm never sure of anything! (unless I see it in front of my face)

Biff

"Dave Peterson" wrote in message
...
In my head, 0 is the closest to 0.

I'm not sure if the OP wants the closest non-zero to zero or what.

Are you positive that the OP wanted it that way? <vbg

(but thanks for the tweaks no matter which way the OP meant.)

Biff wrote:

=INDEX(A1:A30,MATCH(TRUE,ABS(A1:A30)=MIN(ABS(A1:A 30)),0))

Doesn't account for zero.

Just a slight tweak:

=INDEX(A1:A20,MATCH(TRUE,ABS(A1:A20)=MIN(IF(ABS(A1 :A20)0,ABS(A1:A20))),0))

Biff

"Dave Peterson" wrote in message
...
One mo

=INDEX(A1:A30,MATCH(TRUE,ABS(A1:A30)=MIN(ABS(A1:A3 0)),0))

This is an array formula. Hit ctrl-shift-enter instead of enter. If
you
do it
correctly, excel will wrap curly brackets {} around your formula.
(don't
type
them yourself.)

Adjust the range to match--but you can't use the whole column.

Dante wrote:

I am trying to find a function that will sort out numbers in a column
(pos &
neg) and tell me wich one is closest to zero.

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson