How to differentiate zero from blank?

[actjfc]

I have two cells, let’s say, A1 and B1.

They may hold blanks or zeros, I need a way to identify when both are blanks or both are zeros. So, I did this:
D10=(1-(A1=””)*(B1=””))*(A1=0)*(B1=0)

I test it this way:
(A1=”” and B1=””) results in D10 =0, and
(A1=0 and B1=0) results in D10 =1, both results are ok for my project!

But,
Any other combination: A1=0 and B1=”” or A1=”” and B1=0 must result in D10=0, This is my issue, Excels seems to take both "" and 0 as the same. Am I right about it? How Can I get 0 (FALSE) in D10? Where my logic is faulty?

Thanks!

 

[wideboydixon]

Perhaps:

=IF(AND(A1=0,B1=0,A1<>"",B1<>""),1,0)

WBD

 

[Rick Rothstein]

Perhaps:

=IF(AND(A1=0,B1=0,A1<>"",B1<>""),1,0)

Another way...

=IF(OR(A1&B1={"00",""}),1,0)

 

[Scott Huish]

How about:
=1-(COUNTBLANK(A1:B1)=2)

 

[Rick Rothstein]

How about:
=1-(COUNTBLANK(A1:B1)=2)

The OP said he wanted to know when both were blank or both were 0... your formula does that, but it also reports 1 if one is blank and the other is 0.

 

[actjfc]

I thought this IF(OR(A1&B1={"00",""}),1,0) will make it, but not, it is more complicated than I initially thought.

Blank - Blank must be False,
Zero - Zero must be True,
>0 - Blank must be True,
Blank - >0 must be False,
0 - >0 must be False

it is a tricky one! Now, I understand the challenge better.

Thanks!

 

[Scott Huish]

Yes, there is that. Yours returns 1 if both are blank, which isn't quite correct either.

Back to the drawing board.

 

[Scott Huish]

=1-OR(COUNTIF(A1:B1,0)<>2,COUNTBLANK(A1:B1)=2)

 

[Rick Rothstein]

Yours returns 1 if both are blank, which isn't quite correct either.

But the OP said "I need a way to identify when both are blanks or both are zeros".

 

[Scott Huish]

The op said this:

I test it this way:
(A1=”” and B1=””) results in D10 =0, and
(A1=0 and B1=0) results in D10 =1, both results are ok for my project!