Finding Zeros

[Seahorsenerd]

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

 

[Gary''s Student]

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

 

[David Biddulph]

=MIN(ABS(B3:B367))