Lookup most close number.

C

Cactus

I want to lookup a number it is most close zero in a numbers group.
and choice that number.

-10 -7 2 -10 -17 -7

for example. that 2 is most close 0 in group.

is exist a function to do that?

or must write my function by VBA.

thanks.
 
B

Bob Phillips

Isn't it just

=MIN(ABS(A1:F1))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top