What I am attempting to do is search if 2 cells contain specific text. For example in Column C I want to output "Yes" only if cell A and B are Yes otherwise the output is "No".
A B C
1 Yes Yes Yes
2 Yes No No
3 No No No
Any help would be much appreciated. Its probably simple
I have tried =IF(A1=B1="Yes", "Yes, "No") to no avail
Last edited by Verifyor; 08-07-2014 at 06:17 AM.
Hi :-)
You can do this with a simple formula in C, such as:
Edit:
Please Login or Register to view this content.
To ensure you take care of blanks, you can do the following (and copy down)
Hope this helps!Please Login or Register to view this content.
Jenn
Perfect, Thank You!
Very welcome! :-)
simpler is
=if(a1&b1="yesyes","yes","no")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks