yes or no results spreadsheet

Giganews Newsgroups
Subject: yes or no results spreadsheet
Posted by:  KO
Date: Tue, 23 May 2006

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.

Replies