Link to an empty cell question.

[h2fcell]

Hello,

I have a cell with a link to another cell which will either be blank(empty)
or contains a number. Currently, when the source cell is empty a “0†appears
in the destination cell. If the source is empty I’d like the link to return
a null instead of “0â€.
Is there a setting to do that without using “=IF()†in the link cell?
I also would not like to use a space to clear the source cell.

Any ideas are appreciated.

 

[Gary''s Student]

You must explicitly test:

=IF(A1="","",A1)

 

[Ron@Buy]

An option is to hide the zero - in Excel 2003

On the Tools menu, click Options, and then click the View tab.
Do one of the following:
1. To display zero (0) values in cells, select the Zero values check box
2. To display zero values as blank cells, clear the check box.

or

You could use conditional format to change the colour of the zero to match
the background colour of the cell (assuming your cell is white):

1. Select the cell that contains the zero (0) value.
2. On the Format menu, click Conditional Formatting.
3. In the box on the left, click Cell Value Is.
4. In the second box from the left, click equal to.
5. In the box on the right, type 0.
6. Click Format, and then click the Font tab.
7. In the Color box, select white

Both these methods have been copied from Microsoft help files.

Hope this helps