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