yes or no results spreadsheet
 

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.

yes or no results spreadsheet
 

=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.

yes or no results spreadsheet
 

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.

yes or no results spreadsheet
 

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

yes or no results spreadsheet
 

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.

yes or no results spreadsheet
 

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")

yes or no results spreadsheet
 

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.

yes or no results spreadsheet
 

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")