Not displaying a value
 

I have a cell that references a cell on another tab, so what ever is typed in
a cell on the first tab gets transferred onto the second tab. The problem is,
that when the first tab cell has nothing in it, the second tab shows a value
"0". I would prefer that it just remains blank like the first tab.

Thanks

Not displaying a value
 

One way:

=IF(Sheet1!A1="","",Sheet1!A1)

In article ,
KB wrote:

I have a cell that references a cell on another tab, so what ever is typed in
a cell on the first tab gets transferred onto the second tab. The problem is,
that when the first tab cell has nothing in it, the second tab shows a value
"0". I would prefer that it just remains blank like the first tab.

Thanks

Not displaying a value
 

You could use an IF statement. Something like:

=IF('Sheet 1'!A1="","",'Sheet 1'!A1)

HTH,
Elkar


"KB" wrote:

I have a cell that references a cell on another tab, so what ever is typed in
a cell on the first tab gets transferred onto the second tab. The problem is,
that when the first tab cell has nothing in it, the second tab shows a value
"0". I would prefer that it just remains blank like the first tab.

Thanks

Not displaying a value
 

=IF(Sheet1!A1<"",Sheet1!A1,"")


Gord Dibben MS Excel MVP


On Thu, 17 May 2007 10:48:00 -0700, KB wrote:

I have a cell that references a cell on another tab, so what ever is typed in
a cell on the first tab gets transferred onto the second tab. The problem is,
that when the first tab cell has nothing in it, the second tab shows a value
"0". I would prefer that it just remains blank like the first tab.

Thanks