An empty cell = An empty cell ???

  • Thread starter Thread starter amirstal
  • Start date Start date
A

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
 
Use the IsBlank() worksheet function somewhere in your formula to check
both cells first.
 
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
Click to expand...
 
Back
Top