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.
