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),"")

[TABLE="width: 300"]
<tbody>[TR]
[TD]Subs.[/TD]
[TD] Cie[/TD]
[TD]Curr[/TD]
[TD] Amounts[/TD]
[/TR]
[TR]
[TD]Example[/TD]
[TD]ABC[/TD]
[TD]USD[/TD]
[TD] (250,000)[/TD]
[/TR]
[TR]
[TD]Example[/TD]
[TD]DEF[/TD]
[TD]USD[/TD]
[TD] 757,712[/TD]
[/TR]
[TR]
[TD]Example[/TD]
[TD]IJK[/TD]
[TD]USD[/TD]
[TD] 198,723[/TD]
[/TR]
[TR]
[TD]Example[/TD]
[TD]LMN[/TD]
[TD]USD[/TD]
[TD] -[/TD]
[/TR]
[TR]
[TD]Example[/TD]
[TD]OPQ[/TD]
[TD]USD[/TD]
[TD] 2,500,000[/TD]
[/TR]
</tbody>[/TABLE]

 

[Myrko]

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

Does this work for you?

 

[Nakeele]

it works!! Thanks!