Trying to make multiple formula cell

[highfive414]

I have 4 cells, A3,B3,C3, and D3.

=IF(OR(A3="",B3="",C3=""),"",A3+B3+C3) (for when D3 is absent)
=IF(OR(A3="",C3="",D3=""),"",A3-C3-D3) (for when B3 is absent)

How can I combine these two formulas into one cell?

Like if I did not put a value for B3, but did put a value for D3, the
second formula's answer would come out and if I did put a value for B3
and not for D3, the first formula's answer would pop out of the same
cell.

Help~

 

[Arvi Laanemets]

Hi

=IF(AND(B3<>"",D3=""),SUM(A3:C3),IF(B3="",D3<>"",SUM(A3,-(C33)),""))