Hi

=IF(AND(B3<"",D3=""),SUM(A3:C3),IF(B3="",D3<"",S UM(A3,-(C3:D3)),""))


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


wrote in message
oups.com...
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~