Trying to make multiple formula cell

[[email protected]]

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,-(C3:D3)),""))


--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )


<[email protected]> wrote in message
news:[email protected]...
>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~
>