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
|