Multicondition If with And function (TEXT)

D

dapos

Joined
Sep 25, 2006
Messages
3
Reaction score
0
Hi all
i tried to compare 2 different cells with text inside.Each cell contains "yes","no"," ", 6 possible values
For example
A B C
1 YES NO
2 YES YES
3 YES " "
4 NO YES
5 NO NO
6 NO " "
In column b i want to enter the result f.e. if a1="yes" and b1="yes" do 1,if a2="yes" and b2="no" do 2 and so on
There is a function for this ?
Any help will be great...Thanks
 
CORRECTION


Hi all
i tried to compare 2 different cells with text inside.Each cell contains "yes","no"," ", 6 possible values
For example
A B C
1 YES NO
2 YES YES
3 YES " "
4 NO YES
5 NO NO
6 NO " "
In column C, i want to enter the result f.e. if a1="yes" and b1="yes" do 1,if a2="yes" and b2="no" do 2 and so on
There is a function for this ?
Any help will be great...Thanks
 
check out
if(and statement such as

=IF((AND(A1="yes",B1="no")),1,(IF((AND(A1="yes",B1="yes")),2,(IF((AND(A1="no",B1="yes")),3,(IF((AND(A1="no",B1="no")),4)))))))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

min if horizontal 0
How do I count # of cells with same value other column? 4
how to count#cells w/= value in other column and not count blank c 4
Comparison of columns using Conditional Formatting 3
having problems with a multiple conditions nesting formula 3
IF/AND Formula Problem 9
Idetnifying repeats in a column 1
Sum with 2 if's 1

Back
Top