Min function without zeros
=MIN(IF(A1:A10<0,A1:A10))
which is an array formula, so commit with Ctrl-Shift-Enter, not just Enter.
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"dragea" wrote in message
...
I have a spreadsheet with 4 cells in four different worksheets that I want
to
find the min value that isn't zero. How can I make the Min function work
and
not pick up the zero?
|