up vote 1 down vote favorite
share [g+] share [fb]

I am trying to create a formula using a cell that holds data linked from another tab in the same spreadsheet. When the source cell is blank, the linked cell shows "0". Is there a way to have the linked cell show up as blank instead of showing "0"? I am having trouble using the cell showing "0" in other formulas.

link|improve this question
feedback

migrated from stackoverflow.com May 18 '11 at 23:19

This question came from our site for professional and enthusiast programmers.

3 Answers

up vote 2 down vote

It's better to use ISBLANK. 

=if(ISBLANK(A1), "", formula)

Replace A1 with your reference cell and formula with what you want this cell to contain if A1 isn't blank.

link|improve this answer
Thank you so much! – Sarah May 12 '11 at 3:18
@Sarah if this answer solved your problem, please consider accepting it – chris neilsen May 12 '11 at 8:12
feedback
up vote 2 down vote

Use the code =If(IsBlank(sheetname!cellnumber),"",sheetname!cellnumber) and where sheetname is Sheet1,Sheet2, etc, and cellnumber is A1,A2,B5,etc.

link|improve this answer
feedback
up vote 1 down vote

Use this formula:

=IF(CELLNAME=0, "", CELLNAME)

Replace CELLNAME with the actual name of the cell you're referencing.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard