Blank Cell

  • Thread starter Thread starter Tonks
  • Start date Start date
T

Tonks

I want a cell that has a formula to appear empty until I enter data into the
cell it's referring to. I am getting a zero and I want it to appear empty.
 
Tonks said:
I want a cell that has a formula to appear empty until I enter data into
the
cell it's referring to. I am getting a zero and I want it to appear empty.
Click to expand...

I think you want this paradigm:

=if(A1="", "", A1*2)

Caveat: If that formula is in A2, then use A2="", not ISBLANK(A2), to test
if A2 is __appears__ empty. Also, since A2 is not truly empty, formulas
like =A2*3 will not work when A2 evaluates to "" (null string). Use N(A2);
for example, =N(A2)*3
 
The formula that I think I need to use is this one. I don't know where or how
to enter that I want it to remain blank until I've entered my data into B2
=SUM(IF((B2>0),C1+B2))
 
Try this

=IF(B2>0,C1+B2,"")

Mike

Tonks said:
The formula that I think I need to use is this one. I don't know where or how
to enter that I want it to remain blank until I've entered my data into B2
=SUM(IF((B2>0),C1+B2))
Click to expand...
 
Back
Top