SMALL formula with negative values only and excluding 0

[Nakeele]

Hi Guys,

I have a the table below. I'm trying to get the smallest value with negative values only and excluding 0.
If there are no negative values it should show a blank cell.

I tried using OR and AND. It works with OR as long as there is a negative value. It doesn't work with AND.

Thanks for your help!


Array formula, where Column E is Amounts :

IFERROR(SMALL(IF(OR(E2:E6<0,E2:E6<>0),E2:E6),1),"")

Subs.	Cie	Curr	Amounts
Example	ABC	USD	(250,000)
Example	DEF	USD	757,712
Example	IJK	USD	198,723
Example	LMN	USD	-
Example	OPQ	USD	2,500,000

<tbody>
</tbody>

 

[Myrko]

=IF(MIN(E2:E6)>=0,"",MIN(E2:E6))

Does this work for you?

 

[Nakeele]

it works!! Thanks!