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'),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Excel - Wich Function should I use? 1
Getting Radio Buttons to work, that are inserted via AutoText 0
Calculate the median value before a specified list 0
If, Or, and 5
SUMIF with criteria "<>" & "=" 4
Dcount -Date Criteria - Won´t find it - 0
Referencing the values of multiple cells in conditinal formatting. 0

Top