Code to show blank instead of 0 when there is no value in linked cell?
 

Sometimes, a cell is blank whose contents are being linked to in
another sheet in a workbook. When that is the case, instead of 0,
what can we put in the code to just show a blank as well in the second
sheet? Right now, if the cell is blank, the link cell shows a "0".
Thank you.

Code to show blank instead of 0 when there is no value in linked cell?
 

Hi

You can use something like

=IF(SOURCE<"",YOUR FORMULA,"")

Govind.

-----Original Message-----
Sometimes, a cell is blank whose contents are being
linked to in
another sheet in a workbook. When that is the case,
instead of 0,
what can we put in the code to just show a blank as well
in the second
sheet? Right now, if the cell is blank, the link cell
shows a "0".
Thank you.

.

Code to show blank instead of 0 when there is no value in linked c
 

Try this...

go to tools menu -- option and under the VIEW tab remove the tick mark
against the ZERO VALUES.

Mustafa

"StargateFan" wrote:

Sometimes, a cell is blank whose contents are being linked to in
another sheet in a workbook. When that is the case, instead of 0,
what can we put in the code to just show a blank as well in the second
sheet? Right now, if the cell is blank, the link cell shows a "0".
Thank you.

Code to show blank instead of 0 when there is no value in linked cell?
 

On Sun, 20 Mar 2005 18:21:51 -0800, "Govind"
wrote:

Hi

You can use something like

=IF(SOURCE<"",YOUR FORMULA,"")

That's great! I knew it would have to be something like that, it was
the link part that was giving me problems. I was given this type of
code last year and use it all the time, but now it's great. I have
the means to use when linking, too.

My formula trial just now worked perfectly with this:

=IF(Sheet1!A1<"",Sheet1!A1,"")

Fabulous.

Thanks!

Govind.

-----Original Message-----
Sometimes, a cell is blank whose contents are being
linked to in
another sheet in a workbook. When that is the case,
instead of 0,
what can we put in the code to just show a blank as well
in the second
sheet? Right now, if the cell is blank, the link cell
shows a "0".
Thank you.

.