software

It's a very basic formula: it simply returns data from another worksheet
in the workbook. However, if no data is entered in the cell a quot;0quot; will
be inserted in any cell that references it. I tried IF with a space for
value_if_true, like so:

=IF('sheet1!A1'=0, , 'sheet1!A1')

But that didn't work; it still returned quot;0quot;. I then tried replacing the
space with a non-breaking space (Alt 0160); that returned an error.
Any Ideas?

~Jonathan--
jonlandrum

jonlandrum.com/about/
------------------------------------------------------------------------
jonlandrum's Profile: www.excelforum.com/member.php...oamp;userid=33615
View this thread: www.excelforum.com/showthread...hreadid=533945
try

=IF('sheet1!A1'=0,quot;quot; , 'sheet1!A1')

regards--
tony h
------------------------------------------------------------------------
tony h's Profile: www.excelforum.com/member.php...oamp;userid=21074
View this thread: www.excelforum.com/showthread...hreadid=533945
tony, it worked beautifully. Thank you very much! I don't know why I
didn't post that question here six months ago. I've just been coloring
the zeros white. )

Now I have to find another excuse for spending all day with these
files.

~Jonathan--
jonlandrum

jonlandrum.com/about/
------------------------------------------------------------------------
jonlandrum's Profile: www.excelforum.com/member.php...oamp;userid=33615
View this thread: www.excelforum.com/showthread...hreadid=533945You could also use a custom format of General;General;

and then just use

='sheet1!A1'

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jonlandrumquot; gt; wrote
in message ...
gt;
gt; tony, it worked beautifully. Thank you very much! I don't know why I
gt; didn't post that question here six months ago. I've just been coloring
gt; the zeros white. )
gt;
gt; Now I have to find another excuse for spending all day with these
gt; files.
gt;
gt; ~Jonathan
gt;
gt;
gt; --
gt; jonlandrum
gt;
gt; jonlandrum.com/about/
gt; ------------------------------------------------------------------------
gt; jonlandrum's Profile:
www.excelforum.com/member.php...oamp;userid=33615
gt; View this thread: www.excelforum.com/showthread...hreadid=533945
gt;

Bob, I didn't think of that, either. However, it wouldn't work because
the formating has to be either in date format or dollar format.--
jonlandrum

jonlandrum.com/about/
------------------------------------------------------------------------
jonlandrum's Profile: www.excelforum.com/member.php...oamp;userid=33615
View this thread: www.excelforum.com/showthread...hreadid=533945You can still use the technique

Assuming you never get negative dates

dd/mmm/yyyy;;

But with currency

£#,##0.00;-£#,##0.00;

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jonlandrumquot; gt; wrote
in message ...
gt;
gt; Bob, I didn't think of that, either. However, it wouldn't work because
gt; the formating has to be either in date format or dollar format.
gt;
gt;
gt; --
gt; jonlandrum
gt;
gt; jonlandrum.com/about/
gt; ------------------------------------------------------------------------
gt; jonlandrum's Profile:
www.excelforum.com/member.php...oamp;userid=33615
gt; View this thread: www.excelforum.com/showthread...hreadid=533945
gt;