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
Bookmarks