Thread: IF Functions
View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

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

--

HTH

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


"Krissy" wrote in message
...
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?