Omer

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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
 
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
 
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
 
Back
Top