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

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

try this

=if(a2="yes"or b2="yes,"yes","no")



"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

Did *you* try it?

In article ,
CmK wrote:

try this

=if(a2="yes"or b2="yes,"yes","no")

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

Here is my attempt at it...

=IF(AND(A1="no",B1="no"),"no","yes")

Rick

sorry i didnt it dosent work?

"JE McGimpsey" wrote:

Did *you* try it?

In article ,
CmK wrote:

try this

=if(a2="yes"or b2="yes,"yes","no")

Thanks alot all of you, just one more query

if either column A has "yes" or column B has "yes", column C should show
"yes" too but if BOTH columns "A" or "B" has "N/A" "C" should say "N/A",
With you guys formula "C" is giving me "No"

let make this
A B C
Yes no yes
No Yes Yes
Yes Yes Yes
No no No
N/A N/A N/A

"Rick Rothstein (MVP - VB)" 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













Here is my attempt at it...

=IF(AND(A1="no",B1="no"),"no","yes")

Rick

if either column A has "yes" or column B has "yes", column C should show
"yes" too but if BOTH columns "A" or "B" has "N/A" "C" should say "N/A",
With you guys formula "C" is giving me "No"

let make this
A B C
Yes no yes
No Yes Yes
Yes Yes Yes
No no No
N/A N/A N/A

Do you mean "N/A" as an enter piece of text??? If either column contains a
genuine N/A error, then column C will get an N/A error too. Instead of
putting "N/A" as text in one or both columns, use =NA() and watch what our
functions do.

Rick

"Omer" wrote:

Thanks alot all of you, just one more query

if either column A has "yes" or column B has "yes", column C should show
"yes" too but if BOTH columns "A" or "B" has "N/A" "C" should say "N/A",
With you guys formula "C" is giving me "No"

Omar

The following should work whether or not "N/A" is text or a formular error
#N/A
=IF(OR(ISERROR($A4),ISERROR($B4)),NA(),IF(A2="Yes" ,"Yes",IF(OR(B2="Yes",A2="Yes"),"Yes",IF(AND(A2="N o",B2="No"),"No","No"))))

Be careful of the wrapping, maybe copy it into Notepad and edit it there to
make sure there are no breaks. then copy from Notepad.

Regards
Peter

Or to keep the formating the same

=IF(OR(ISERROR($A6),ISERROR($B6)),NA(),IF(OR($A6=" Yes",$B6="Yes"),"Yes",IF(OR(A6="N/A",B6="N/A"),"N/A","No")))

Peter