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!

 

[actjfc]

Sorry, there is one more case: >0 - >0 must be True. Thanks for any help! I am working on it!

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
>0 - >0 must be True

 

[Rick Rothstein]

The op said this:

Yes, I just saw that... but, of course, as it turns out, the OP did not actually ask his real question in Message #1 .

 

[Rick Rothstein]

Sorry, there is one more case: >0 - >0 must be True. Thanks for any help! I am working on it!

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
>0 - >0 must be True

What about for these which you omitted from your list...

Zero-Blank
Blank-Zero
>0 - 0

 

[Scott Huish]

=or(and(a1=0,b1=0,count(a1:b1)=2),and(a1>0,b1=""),and(a1>0,b1>0))+0

 

[Aladin Akyurek]

Either both numeric or both empty/blank...

=XOR(AND(ISNUMBER(A1),ISNUMBER(B1)),AND(LEN(A1)=0,LEN(B1)=0))

 

[Scott Huish]

That function is available on Excel 2013 and higher, but I don't think that addresses the conditions that came later in the thread.

 

[actjfc]

Thanks Rick Rothstein! You are right! I missed them!

Zero-Blank - False
Blank-Zero - False
>0 - 0 - True

I am so sorry, I corrected this one : >0 - Blank must be False.

 

[Rick Rothstein]

Thanks Rick Rothstein! You are right! I missed them!

Zero-Blank - False
Blank-Zero - False
>0 - 0 - True

I am so sorry, I corrected this one : >0 - Blank must be False.

I believe this formula will work for you...

=0+OR(A1&B1="00",AND(A1>0,B1<>""))

 

[actjfc]

Wow! Amazing! Simple and powerful! Perfect! Huge Thanks!