Blank Cell
 

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.

Blank Cell
 

post this formula and someone will help

"Tonks" wrote:

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.

Blank Cell
 

"Tonks" wrote:
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

Blank Cell
 

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((B20),C1+B2))

"Mike H" wrote:

post this formula and someone will help

"Tonks" wrote:

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.

Blank Cell
 

Try this

=IF(B20,C1+B2,"")

Mike

"Tonks" wrote:

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((B20),C1+B2))

"Mike H" wrote:

post this formula and someone will help

"Tonks" wrote:

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.

Blank Cell
 

That's exactly what I needed. Thank you!

"Mike H" wrote:

Try this

=IF(B20,C1+B2,"")

Mike

"Tonks" wrote:

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((B20),C1+B2))

"Mike H" wrote:

post this formula and someone will help

"Tonks" wrote:

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.