| 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 | |||
Hybrid Mode
