Bob: How about if zero is in the column?
--
Gary''s Student
"Bob Phillips" wrote:
=MIN(IF(F1:F20<0,ABS(F1:F20)))*SIGN(IF(F1:F20<0, F1:F20))
which is an array formula, so commit with Ctrl-Shift-Enter
--
HTH
Bob Phillips
"Dante" wrote in message
...
I am trying to find a function that will sort out numbers in a column (pos
&
neg) and tell me wich one is closest to zero.
|