IF formula doesn't work

I

Ivan_Cabral

sorry for my poor english...

a1- 2
b1- 2

=if(a1=b1;"1";"0") this is ok BUT when the cells BLANK the result is one too.

How i hide the result when A1 is blank, i need knows the result just when in it

thanks a lot
 
B

Bob Greenblatt

sorry for my poor english...

a1- 2
b1- 2

=if(a1=b1;"1";"0") this is ok BUT when the cells BLANK the result is one too.

How i hide the result when A1 is blank, i need knows the result just when in
it

thanks a lot
Click to expand...
=if(len(a1)>0,if(a1=b1,"1","0'),"")
 
Top