View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KO
 
Posts: n/a
Default 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.