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
"Maya" wrote in message
...
I have
=if(and(a1="1",b1="y"),c1)
and all I get is "FALSE"
what am I doing wrong
"Peo Sjoblom" wrote:
=IF(AND(A1="x",B1="y"),C1)
Regards,
Peo Sjoblom
"Maya" wrote:
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
|