IF Functions

=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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> In E3: =IF(B3+D3=0,"",B3+D3)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Krissy" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> In E3: =IF(B3+D3=0,"",B3+D3)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Krissy" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>