Good day to you all,

I'm going to be embarrassed here as I can't for the life of me figure something that appears to be so simple out, here goes,

I have two cells, A1 and B1 that are blank, in cell C1 I have a formula =IF(A1=B1,1,0). The idea is to type numbers in A1 and B1 and if the are equal the value 1 appears in C1 and if not the value 0 will appear.

However, with both A1 and B1 empty and as soon as I type the formula above into C1 and hit enter, I get the value 1.

Can somebody, point me in the right direction please.

Yours, an embarrassed,
seraphim666