Omer
 

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

Omer
 

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

Omer
 

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

Omer
 

Did *you* try it?

In article ,
CmK wrote:

try this

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

Omer
 

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

Omer
 

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")

Omer
 

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

Omer
 

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
 

"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

Omer
 

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