1
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.
2
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.
2
Use the code =If(IsBlank(sheetname!cellnumber),"",sheetname!cellnumber) and where sheetname is Sheet1,Sheet2, etc, and cellnumber is A1,A2,B5,etc.
soandos
Posted 2011-05-12T01:47:02.893
Reputation: 22 744
1
Use this formula:
=IF(CELLNAME=0, "", CELLNAME)
Replace CELLNAME with the actual name of the cell you're referencing.
Brian Willis
Posted 2011-05-12T01:47:02.893
Reputation: 672
@Sarah if this answer solved your problem, please consider accepting it – chris neilsen – 2011-05-12T08:12:02.070