Omer

[Guest]

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

 

[JE McGimpsey]

One way:

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

copy down as necessary.

 

[Guest]

try this

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

 

[JE McGimpsey]

Did *you* try it?

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Guest]

sorry i didnt it dosent work?

Did *you* try it?

 

[Guest]

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\)]

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

 

[Guest]

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="No",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

 

[Guest]

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