An empty cell = An empty cell ???

[amirstal]

When I use two empty cells, excel treats them as if they contain the
same, equal data. So, for example, if both A1 and A2 are empty, the
following formula will return "1": IF(A1=A2,"1").

But I don't want excel to treat those two cells as being equal as long
as they don't really contain any data. So in this case, the above
formula will not return the number "1".
How can I do it?

Thanks,

Amir

 

[Bill Renaud]

Use the IsBlank() worksheet function somewhere in your formula to check
both cells first.

 

[Dave Peterson]

Maybe...

=if(and(a1=a2,a1<>""),1,0)

When I use two empty cells, excel treats them as if they contain the
same, equal data. So, for example, if both A1 and A2 are empty, the
following formula will return "1": IF(A1=A2,"1").

But I don't want excel to treat those two cells as being equal as long
as they don't really contain any data. So in this case, the above
formula will not return the number "1".
How can I do it?

Thanks,

Amir