IF Functions

K

Krissy

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?
 
B

Bob Phillips

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

--

HTH

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

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)
 
Top