| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when i megre cells that begin with zeros , I lose the zeros | Excel Discussion (Misc queries) | |||
| Essbase: Text zeros to number zeros | Excel Discussion (Misc queries) | |||
| Charting zeros as non zeros | Charts and Charting in Excel | |||
| finding the no. of rows in a COL filled with numbers, zeros and bl | Excel Worksheet Functions | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Hybrid Mode
