How to find the minimum value in the range exclude zero.

=MIN(IF(A1:A10<0,A1:A10))

Entered as an array using the key combo of CTRL,SHIFT,ENTER.

Biff

"cutyfurby" wrote
in message ...

How to find the minimum value in the range exclude zero.


--
cutyfurby
------------------------------------------------------------------------
cutyfurby's Profile:
http://www.excelforum.com/member.php...o&userid=32371
View this thread: http://www.excelforum.com/showthread...hreadid=521326