Blank Cell

[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.

 

[Mike H]

post this formula and someone will help

 

[JoeU2004]

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.

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

 

[Tonks]

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))

 

[Mike H]

Try this

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

Mike

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))

 

[Tonks]

That's exactly what I needed. Thank you!

Try this

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

Mike