equal result zero or blank

[andreisobaru]

Hi,

So when you put a formula in a cell that it is equal to another:
let's say in A1 you write =A2
and A2 is blank
then in A1 it appears 0
but sometimes, just sometimes, when you equal a cell to a blank cell, the first cell remains blank
what determines this behaviour? I need the cells to remain blank when I equal them to a blank cell
I am not looking for a solution like A1=if(A2=0,"",A2), this is not applicable in my case, I simply want to know what determines for the cell with the formula if it shows 0 or remains blank.

thanks,
Andrei

 

[Jonmo1]

Excellent, glad to help.