You can do as follows:

=IF(MIN(IF(B5:B10<0,B5:B10))=0, "No minimum value to display",
MIN(IF(B5:B10<0,B5:B10)))

Press CTRL+SHIFT+ENTER when you finish.

--
Best regards
Robert, Excel MVP
Author of RibbonX: Customizing the Office 2007 Ribbon:
Find me at http://www.msofficegurus.com - be part of it!
FORUM: http://www.msofficegurus.com/forum/