If statement

[abee4life]

Can someone help with an If statement please.

I have tried different variations of how to do what I want, but nothing seems to work.

I want in C1 a formula that tells me if A1 and B1 are the same and if so to return the number 1, if its not then 0. Now, I know the the basic formula would be =if(a1=b1,1,0) but it returns a 1 even if the two cells are empty.

What I want is for C1 to tell me 0 if the cells are blank, or do not have the same numbers as each other. Can someone help please.

 

[Aladin Akyurek]

Can someone help with an If statement please.

I have tried different variations of how to do what I want, but nothing seems to work.

I want in C1 a formula that tells me if A1 and B1 are the same and if so to return the number 1, if its not then 0. Now, I know the the basic formula would be =if(a1=b1,1,0) but it returns a 1 even if the two cells are empty.

What I want is for C1 to tell me 0 if the cells are blank, or do not have the same numbers as each other. Can someone help please.

Assumes numeric entries...

=IF(COUNT(A1:B1)=2,IF(A1=B1,1,0),0)

 

[nise23]

=if(and(a1=b1, not(and(isblank(a1),isblank(b1)))),1,0)

 

[mikerickson]

Try
=COUNTIF(A1,B1)

 

[abee4life]

Many thanks guys