IF and ISBLANK 0 to give a non-empty cell

[kaits68]

I have used the formula in cell A1, then the case of an empty cell in response to 0, but I need an empty box. Cells with formulas (Sheet1! A1), the formulas work, and also on the same worksheet, but other than not wearing. I hope you can understand the google translation =IF(ISBLANK(Sheet1!A1)=TRUE;"";Sheet1!A1)
and second formula =IF(Sheet1!A1="";"";Sheet1!A1)
for example Sheet1!A1 is =B34

 

[Jerry Sullivan]

Hello and Welcome,

If I understand you correctly, you want to display blank cells instead of zeros.
Perhaps this link will help.

http://office.microsoft.com/en-us/excel-help/display-or-hide-zero-values-HP005199879.aspx

Please clarify if I misunderstood.