Home |
Search |
Today's Posts |
#1
|
|||
|
|||
return a " " for null values
I have cells on "Sheet1" whose value is linked to cells on "Sheet2" (direct
1 to 1 link). If i have nothing in the Sheet 2 cells, I need blank cells on Sheet 1, but, of course, I get a "0"... how can I have sheet 1 show a null value. Thanx - David |
#2
|
|||
|
|||
Hi David
Either use formulas like =IF(Sheet1!A1="","",Sheet1!A1) or uncheck "zero values" in Tools Options, View. HTH. Best wishes Harald "David#" skrev i melding ... I have cells on "Sheet1" whose value is linked to cells on "Sheet2" (direct 1 to 1 link). If i have nothing in the Sheet 2 cells, I need blank cells on Sheet 1, but, of course, I get a "0"... how can I have sheet 1 show a null value. Thanx - David |
#3
|
|||
|
|||
David
Be aware that these would not be true NULL values, just look blank. Gord Dibben Excel MVP On Fri, 21 Jan 2005 15:31:37 +0100, "Harald Staff" wrote: Hi David Either use formulas like =IF(Sheet1!A1="","",Sheet1!A1) or uncheck "zero values" in Tools Options, View. HTH. Best wishes Harald "David#" skrev i melding ... I have cells on "Sheet1" whose value is linked to cells on "Sheet2" (direct 1 to 1 link). If i have nothing in the Sheet 2 cells, I need blank cells on Sheet 1, but, of course, I get a "0"... how can I have sheet 1 show a null value. Thanx - David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
Excel Forumla to seach and return all values | Excel Worksheet Functions | |||
Adding multiple cells, return specific values | Excel Worksheet Functions | |||
How to look up and return multiple values | Excel Worksheet Functions |