I have a very simple excel table, 3 columns, many rows.

ColA = response 1 (y or n)
ColB = response 2 (y or n)
ColC = Include (y or n)

What I want ColC to produce is as follows:

If ColA and ColB are both y, then ColC is y
If ColA and ColB are both n, then ColC is n
If ColA and ColB disagree (one y, one n), then ColC is n

I need a formula so I dont have to go through each row (there are 1000 or
so) and enter each response in ColC by hand.

Thanks for your help.

=IF(AND(A1="y",B1="y","y","n")

HTH
--
AP

"KO" a écrit dans le message de news:
...
I have a very simple excel table, 3 columns, many rows.

ColA = response 1 (y or n)
ColB = response 2 (y or n)
ColC = Include (y or n)

What I want ColC to produce is as follows:

If ColA and ColB are both y, then ColC is y
If ColA and ColB are both n, then ColC is n
If ColA and ColB disagree (one y, one n), then ColC is n

I need a formula so I don't have to go through each row (there are 1000 or
so) and enter each response in ColC by hand.

Thanks for your help.

The following formula in column C should do it:


=IF(AND(A1="Y",B1="Y"),"Y","N")

--
Kevin Backmann


"KO" wrote:

I have a very simple excel table, 3 columns, many rows.

ColA = response 1 (y or n)
ColB = response 2 (y or n)
ColC = Include (y or n)

What I want ColC to produce is as follows:

If ColA and ColB are both y, then ColC is y
If ColA and ColB are both n, then ColC is n
If ColA and ColB disagree (one y, one n), then ColC is n

I need a formula so I dont have to go through each row (there are 1000 or
so) and enter each response in ColC by hand.

Thanks for your help.

This is the simplest formula I could think of:
=IF(A1=B1,A1,"n")

In Column C enter:

=IF(AND(A1="y",B1="y"),"y","n")

HTH,
Elkar


"KO" wrote:

I have a very simple excel table, 3 columns, many rows.

ColA = response 1 (y or n)
ColB = response 2 (y or n)
ColC = Include (y or n)

What I want ColC to produce is as follows:

If ColA and ColB are both y, then ColC is y
If ColA and ColB are both n, then ColC is n
If ColA and ColB disagree (one y, one n), then ColC is n

I need a formula so I dont have to go through each row (there are 1000 or
so) and enter each response in ColC by hand.

Thanks for your help.

This will return "n" if both A1 and B1 are "n"

--
AP

"Dave O" a écrit dans le message de news:
...
This is the simplest formula I could think of:
=IF(A1=B1,A1,"n")

Thanks very much Kevin. Very elegant (and simple).

"Kevin B" wrote:

The following formula in column C should do it:


=IF(AND(A1="Y",B1="Y"),"Y","N")

--
Kevin Backmann


"KO" wrote:

I have a very simple excel table, 3 columns, many rows.

ColA = response 1 (y or n)
ColB = response 2 (y or n)
ColC = Include (y or n)

What I want ColC to produce is as follows:

If ColA and ColB are both y, then ColC is y
If ColA and ColB are both n, then ColC is n
If ColA and ColB disagree (one y, one n), then ColC is n

I need a formula so I dont have to go through each row (there are 1000 or
so) and enter each response in ColC by hand.

Thanks for your help.

KO" wrote in message
...

<snip

If ColA and ColB are both n, then ColC is n

<snip

--
Regards


Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Ardus Petus" wrote in message
...
This will return "n" if both A1 and B1 are "n"

--
AP

"Dave O" a écrit dans le message de news:
...
This is the simplest formula I could think of:
=IF(A1=B1,A1,"n")