Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

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

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

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.

share|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

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

share|improve this answer

Use this formula:

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

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

share|improve this answer

You must log in to answer this question.