Omer

O

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
 
R

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
Click to expand...

Here is my attempt at it...

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

Rick
 
O

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
 
R

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
Click to expand...

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
 
B

Billy Liddel

Omer said:
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"
Click to expand...

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
 
B

Billy Liddel

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
 
Top