Take the 2-minute tour ×
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
add comment

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

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

3 Answers

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
add comment

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
add comment

Use this formula:

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

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

share|improve this answer
add comment

Your Answer

 
discard

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