One way:

C1: =IF(OR(A1="Yes",B1="Yes"),"Yes","No")

copy down as necessary.

In article ,
Omer wrote:

Can any body tell me how to do this

if either column A has "yes" or column B has "yes", column C should show
"yes" too

for example
A B C
Yes no yes
No Yes Yes
Yes Yes Yes
No no No