MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Keeping cell blank


Posted by Kevin Smith on January 09, 2002 9:10 AM

In a cell on sheet 2 I have the formula =sheet1!a1. If I haven't input any information into cell a1 on sheet 1 a zero shows up in the cell on sheet 2. Is there anythin I can do to make the cell on sheet 2 remain blank until a value has been entered into the cell on sheet 1. The zero is screwing up my calculations and I only want a zero there if I input it.

Thanks


Posted by Juan Pablo G. on January 09, 2002 9:17 AM

Since formatting won't do use something like

=IF(Sheet1!A1,Sheet1!A1,"")

Juan Pablo G.

Posted by George J on January 09, 2002 9:17 AM

=IF(Sheet1!A1>0,Sheet1!A1," ")

George

Posted by IML on January 09, 2002 9:19 AM

There may be better ways, but
=IF(ISBLANK(Sheet1!A1),"",Sheet1!A1)

comes to mind. Hopefully a blank won't mess up your formula like the zero.

Good luck

Posted by IML on January 09, 2002 9:23 AM

Use this one if...

you want to return a zero when a zero is on sheet 1. I think I may have actually read this question correctly.


Posted by Juan Pablo G. on January 09, 2002 9:44 AM

Re: Use this one if...

Another option....(And i have to admit, you read, i didn't, at least completely)

=IF(LEN(Sheet1!A1),Sheet1!A1,"")

Juan Pablo G.