G Guest Jun 10, 2005 #1 I am trying to get information from Cell A and Cell B and then sum Cell C. I cannot seem to link conditions and need help please
I am trying to get information from Cell A and Cell B and then sum Cell C. I cannot seem to link conditions and need help please
G Guest Jun 10, 2005 #3 I have =if(and(a1="1",b1="y"),c1) and all I get is "FALSE" what am I doing wrong
A Art Jun 10, 2005 #4 If the 1 in A1 is a number, remove the quotes from around the 1 in your formula: =IF(AND(A1=1,B1="y"),C1 Art
If the 1 in A1 is a number, remove the quotes from around the 1 in your formula: =IF(AND(A1=1,B1="y"),C1 Art