All of this conditioning needs to populate the same cell. If it's the first equal statement do this, if it's the second equal statement do the second option. If I understand what you provided correctly, this would be used to populate different cells.
I have a spreadsheet that I'm building in which I need to populate a cell based on the conditions of 2 other cells. My skill level is to get me in trouble, but enough to figure this one out. Following is what my conditions are:
IF D2="O" and E2="L" OR D2="C" and E2="S" do this G2*H2+J2*(-1)...