hiding 0 from a cell

B

billy_bags

I can't figure out why this doesn't work, I keep getting circular references.
i have 3 workbooks. 1 is a summary linked to other 2 which are stored in a
different drive. The summary is I:\abc\etc\[summary.xls]sheet 1'!$d$6).
At the moment the cell inwhich this reference sits has 00:00 which is
mm:ss. I want this cell to remain empty until the cell from which it is
linked is populated with a figure.
so =if(c4=0,'','I:\abc\etc[summary.xls]sheet1'!$d$6)

The response is "the formula you typed contains an error etc etc.
I followed what I thought I had to but no joy.
Any help would be appreciated,
Thanks
 
C

CLR

Try this..........

=if(c4=0,"",'I:\abc\etc[summary.xls]sheet1'!$d$6)

Vaya con Dios,
Chuck, CABGx3
 
B

billy_bags

Thanks - but still not playing ball
actual formula is =IF(E9=0,"",'[clive sumary 1.xls]Sheet1'!$G$7)
problem is now that 0.00 is still showing in cell E9

I've done this formula before and it works over different sheets in the same
workbook but it doesn't seem to work over different workbooks
Bill

CLR said:
Try this..........

=if(c4=0,"",'I:\abc\etc[summary.xls]sheet1'!$d$6)

Vaya con Dios,
Chuck, CABGx3


billy_bags said:
I can't figure out why this doesn't work, I keep getting circular references.
i have 3 workbooks. 1 is a summary linked to other 2 which are stored in a
different drive. The summary is I:\abc\etc\[summary.xls]sheet 1'!$d$6).
At the moment the cell inwhich this reference sits has 00:00 which is
mm:ss. I want this cell to remain empty until the cell from which it is
linked is populated with a figure.
so =if(c4=0,'','I:\abc\etc[summary.xls]sheet1'!$d$6)

The response is "the formula you typed contains an error etc etc.
I followed what I thought I had to but no joy.
Any help would be appreciated,
Thanks
Click to expand...
Click to expand...
 
C

CLR

This formula has nothing to do with changing the display of cell E9, it only
evaluates E9 to see if it's zero or not. What is it exactly your are trying
to do?
E9 is showing 0.00 because it's probably formatted for 2-decimal number and
it actually contains a zero, rather than a blank.

hth
Vaya con Dios,
Chuck, CABGx3



billy_bags said:
Thanks - but still not playing ball
actual formula is =IF(E9=0,"",'[clive sumary 1.xls]Sheet1'!$G$7)
problem is now that 0.00 is still showing in cell E9

I've done this formula before and it works over different sheets in the same
workbook but it doesn't seem to work over different workbooks
Bill

CLR said:
Try this..........

=if(c4=0,"",'I:\abc\etc[summary.xls]sheet1'!$d$6)

Vaya con Dios,
Chuck, CABGx3


billy_bags said:
I can't figure out why this doesn't work, I keep getting circular references.
i have 3 workbooks. 1 is a summary linked to other 2 which are stored in a
different drive. The summary is I:\abc\etc\[summary.xls]sheet 1'!$d$6).
At the moment the cell inwhich this reference sits has 00:00 which is
mm:ss. I want this cell to remain empty until the cell from which it is
linked is populated with a figure.
so =if(c4=0,'','I:\abc\etc[summary.xls]sheet1'!$d$6)

The response is "the formula you typed contains an error etc etc.
I followed what I thought I had to but no joy.
Any help would be appreciated,
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Top