=MIN(ABS(B3:B367))
must be entered as an array formula with CNTRL-SHFT-ENTER instead of ENTER
--
Gary''s Student - gsnu200792


"Seahorsenerd" wrote:

Hey,
I have a speadsheet with a bunch of numbers in Column B From B3 to B367 and
i want to find the number that is closest to zero. (Numbers are rounded off
to 8 decimal places). Is there a function that can find a number in the
column that is closest to zero?

Thanks so much,
Sea