IF Functions

[Guest]

I would like to see if anyone would be able to help me out on this formula?

If B3+D3=o then E3 would have nothing but if C3+D3=any number but 0 that
number would show up on E3 and vice versa

Does this make sense to anyone?

 

[Guest]

=if(C3+D3<> 0, C3+D3,if(B3+D3<>0,B3+D3,"")

 

[Bob Phillips]

In E3: =IF(B3+D3=0,"",B3+D3)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Sorry sent it too soon

=IF(B3+D3<>0,B3+D3,IF(C3+D3<>0,C3+D3,""))

--

HTH

RP
(remove nothere from the email address if mailing direct)