yes or no results spreadsheet

[Guest]

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.

 

[Ardus Petus]

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

HTH

 

[Guest]

The following formula in column C should do it:


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

 

[Dave O]

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

 

[Guest]

In Column C enter:

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

HTH,
Elkar

 

[Ardus Petus]

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

 

[Guest]

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

 

[Sandy Mann]

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

<snip>

--
Regards


Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk