displaying an empty cell

's Computer Specifications

I used to reference cells in our worksheets (e.g. =Sheet1!C6). if
Sheet1!C6 is empty i will get a 0 in my cell. How can i get a blank
cell if Sheet1!C6 is an empty cell?

thanks

's Computer Specifications

Hi,
=if(Sheet1!C6="","",Sheet1!C6)

"Lynn" wrote:

> I used to reference cells in our worksheets (e.g. =Sheet1!C6). if
> Sheet1!C6 is empty i will get a 0 in my cell. How can i get a blank
> cell if Sheet1!C6 is an empty cell?
>
> thanks
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
find empty cells in a column then append row that empty cell is in	vbnewbie	Microsoft Excel Programming	9	29th Jan 2009 09:27 AM
why a reference to an empty cell is not considered empty	=?Utf-8?B?Tmljb3Njb3Q=?=	Microsoft Excel Misc	10	10th Mar 2006 05:36 AM
Finding next empty empty cell in a range of columns	=?Utf-8?B?VW5jbGVCdW4=?=	Microsoft Excel Programming	1	13th Jan 2006 11:22 PM
Empty (NUll) value in cell, not empty string?	Jan Kronsell	Microsoft Excel Discussion	4	20th Nov 2004 05:09 PM
filling empty cell if not empty keep its content!?	Tarek	Microsoft Excel Worksheet Functions	4	23rd Feb 2004 08:48 AM