IF formula question
 

Ok. All I want to do is to say if Col A = "Yes" or Col B = "Yes" I want a
Yes printed in Col C. I can't seem to figure this one out.

Thanks for your assistance.

In C1 =if(or(A1="Yes",B1="Yes"),"Yes","")

"Mad Dog" wrote:

Ok. All I want to do is to say if Col A = "Yes" or Col B = "Yes" I want a
Yes printed in Col C. I can't seem to figure this one out.

Thanks for your assistance.

Hi

Try something like:
=IF(OR(A2="Yes",B2="Yes"),"Yes","")
in C2

--
Andy.


"Mad Dog" wrote in message
...
Ok. All I want to do is to say if Col A = "Yes" or Col B = "Yes" I want
a
Yes printed in Col C. I can't seem to figure this one out.

Thanks for your assistance.