ExcelBanter - Finding Zeros

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Finding Zeros (https://www.excelbanter.com/excel-worksheet-functions/191610-finding-zeros.html)

Seahorsenerd

Finding Zeros

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

Finding Zeros

=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

David Biddulph[_2_]

Finding Zeros

=MIN(ABS(B3:B367))
--
David Biddulph

"Seahorsenerd" wrote in message
...
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

All times are GMT +1. The time now is 11:53 PM.