Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 May 18 '11 at 23:19

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

3 Answers 3

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:


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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.