S
SteveG
How can I format a cell with a link formula so an empty reference cell shows
as a blank rather than as a 0 (zero)?
I'm trying to create a new view of an existing worksheet. I'm using simple
link formula to get the data from the original sheet (e.g. ='Sheet1'!$AE$4).
The problem is that for any empty cell in the original, a get a 0 as a result
of the link formula in my new sheet. I don't want a 0; I want a blank cell.
Any ideas on how to accomplish this?
as a blank rather than as a 0 (zero)?
I'm trying to create a new view of an existing worksheet. I'm using simple
link formula to get the data from the original sheet (e.g. ='Sheet1'!$AE$4).
The problem is that for any empty cell in the original, a get a 0 as a result
of the link formula in my new sheet. I don't want a 0; I want a blank cell.
Any ideas on how to accomplish this?