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 :
<tbody>
</tbody>
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 :
Code:
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>