IF Functions
 

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?

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

"Krissy" wrote:

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?

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?

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)


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