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 "0" 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 "0". I then tried replacing the
space with a non-breaking space (Alt + 0160); that returned an error.
Any Ideas?

~Jonathan


--
jonlandrum

http://jonlandrum.com/about/
------------------------------------------------------------------------
jonlandrum's Profile: http://www.excelforum.com/member.php...o&userid=33615
View this thread: http://www.excelforum.com/showthread...hreadid=533945