If Statements - Multiple formulae

[Ms MIS]

I have a worksheet with 5 columns (A-E)
I want to create a formula in column E to do the following;

If column A = SJN and column C = SJN
Then output B+D
Else If column A = SJN and column C <> SJN
Then output B
Else If column A<>SJN and column C = SJN
Then output D

Can anyone help me?
Thanks.

[SteveG]

Try this.


=IF(AND(A1="SJN",C1="SJN"),SUM(B1,D1),IF(AND(A1="SJN",C1<>"SJN"),B1,IF(AND(A1<>"SJN",C1="SJN"),D1,"")))


Cheers,
Steve

[Bruno Campanini]

"Ms MIS" <[email protected]> wrote in message
news:[email protected]...
>I have a worksheet with 5 columns (A-E)
> I want to create a formula in column E to do the following;
>
> If column A = SJN and column C = SJN
> Then output B+D
> Else If column A = SJN and column C <> SJN
> Then output B
> Else If column A<>SJN and column C = SJN
> Then output D

=IF(AND(A1="SJN",C1="SJN"),B1+D1,
IF(AND(A1="SJN",C1<>"SJN"),B1,
IF(AND(A1<>"SJN",C1="SJN"),D1,)))

Ciao
Brunio

[Stefi]

It's not clear what is SJN, so I supposed it's a string. Type in E1 and fill
down as needed:

=IF(AND(A1="sjn",C4="sjn"),B1&D1,IF(AND(A1="sjn",C1<>"sjn"),B1,IF(AND(A1<>"sjn",C1="sjn"),D1,"not thought of")))

Regards,
Stefi

„Ms MIS” ezt �*rta:

> I have a worksheet with 5 columns (A-E)
> I want to create a formula in column E to do the following;
>
> If column A = SJN and column C = SJN
> Then output B+D
> Else If column A = SJN and column C <> SJN
> Then output B
> Else If column A<>SJN and column C = SJN
> Then output D
>
> Can anyone help me?
> Thanks.

[Ron Coderre]

Try this:
For values in Row 2:
E2: =(A2="SJN")*B2+(C2="SJN")*D2

Does that help?

***********
Regards,
Ron


"Ms MIS" wrote:

> I have a worksheet with 5 columns (A-E)
> I want to create a formula in column E to do the following;
>
> If column A = SJN and column C = SJN
> Then output B+D
> Else If column A = SJN and column C <> SJN
> Then output B
> Else If column A<>SJN and column C = SJN
> Then output D
>
> Can anyone help me?
> Thanks.

[Ms MIS]

Perfect, much appreciated.

"SteveG" wrote:

>
> Try this.
>
>
> =IF(AND(A1="SJN",C1="SJN"),SUM(B1,D1),IF(AND(A1="SJN",C1<>"SJN"),B1,IF(AND(A1<>"SJN",C1="SJN"),D1,"")))
>
>
> Cheers,
> Steve
>
>
> --
> SteveG
> ------------------------------------------------------------------------
> SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
> View this thread: http://www.excelforum.com/showthread...hreadid=491840
>
>

[Kleev]

Nothing against the other solutions, but I like this one.

"Ron Coderre" wrote:

> Try this:
> For values in Row 2:
> E2: =(A2="SJN")*B2+(C2="SJN")*D2
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
>
> "Ms MIS" wrote:
>
> > I have a worksheet with 5 columns (A-E)
> > I want to create a formula in column E to do the following;
> >
> > If column A = SJN and column C = SJN
> > Then output B+D
> > Else If column A = SJN and column C <> SJN
> > Then output B
> > Else If column A<>SJN and column C = SJN
> > Then output D
> >
> > Can anyone help me?
> > Thanks.