How to do multiple conditions in one formula; and/or use a string as a condition?
Replace the "0" by the second formula

=IF(BM16=−1,1,if(BK16&gt;0, "", if(BM16 &gt; -1 , "", "O"))) 


anything after = is a formula and can be used where you want a value