hiding 0 from a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

billy_bags - 29 Jan 2007 19:23 GMT

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

Reply to this Message

Don Guillett - 29 Jan 2007 19:57 GMT

"
""

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I can't figure out why this doesn't work, I keep getting circular
>references.
[quoted text clipped - 9 lines]
> Any help would be appreciated,
> Thanks

Reply to this Message

CLR - 29 Jan 2007 20:05 GMT

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

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

Vaya con Dios,
Chuck, CABGx3

> 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
[quoted text clipped - 8 lines]
> Any help would be appreciated,
> Thanks

Reply to this Message

billy_bags - 29 Jan 2007 23:23 GMT

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

> Try this..........
>
[quoted text clipped - 15 lines]
> > Any help would be appreciated,
> > Thanks

Reply to this Message

CLR - 30 Jan 2007 15:47 GMT

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

> Thanks - but still not playing ball
> actual formula is =IF(E9=0,"",'[clive sumary 1.xls]Sheet1'!$G$7)
[quoted text clipped - 23 lines]
> > > Any help would be appreciated,
> > > Thanks

Reply to this Message