Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying Percentiles | Excel Worksheet Functions | |||
leading zero not displaying | Excel Discussion (Misc queries) | |||
Not Displaying Zero Values | Charts and Charting in Excel | |||
Displaying a different value | Excel Discussion (Misc queries) | |||
Displaying #N/A as a zero | Excel Worksheet Functions |