M
MidlandC
I'd like a simple equation. With a complication. The Equation is simply
"=A1". The complication is that if A1 is blank, I want a blank cell, not
zero ("0"). You can test for a blank cell with ISBLANK, but if you say
"If(isblank(A1),"",A1), you don't get a blank cell, you get a cell containing
no visible characters.
"=A1". The complication is that if A1 is blank, I want a blank cell, not
zero ("0"). You can test for a blank cell with ISBLANK, but if you say
"If(isblank(A1),"",A1), you don't get a blank cell, you get a cell containing
no visible characters.