| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Link cell show zero when source cell is blank
In worksheet 'Strategy Map,' cell K7 has link formual ='Objective C1'!AV21.
In worksheet 'Objective C1,' cell AV21 is blank; however, K7 holds a zero. The format for both cells is percent, but even changing them to text does not change the zero value in K7. How do I get K7 to be blank? Thanks, Phil |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link cell show zero when source cell is blank
=if('Objective C1'!av21="","",'objective c1'!av21)
is one way. Phil Hageman wrote: In worksheet 'Strategy Map,' cell K7 has link formual ='Objective C1'!AV21. In worksheet 'Objective C1,' cell AV21 is blank; however, K7 holds a zero. The format for both cells is percent, but even changing them to text does not change the zero value in K7. How do I get K7 to be blank? Thanks, Phil -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link cell show zero when source cell is blank
Hi Dave,
Thanks for your answer - it solves the problem. In this "zero" a characteristic of Excel? Don't remember it coming up before. Thanks, Phil "Dave Peterson" wrote: =if('Objective C1'!av21="","",'objective c1'!av21) is one way. Phil Hageman wrote: In worksheet 'Strategy Map,' cell K7 has link formual ='Objective C1'!AV21. In worksheet 'Objective C1,' cell AV21 is blank; however, K7 holds a zero. The format for both cells is percent, but even changing them to text does not change the zero value in K7. How do I get K7 to be blank? Thanks, Phil -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link cell show zero when source cell is blank
It's been part of excel for as long as I can remember.
And IIRC, Lotus 123 release 2.4 did it the same way (last version I used). Phil Hageman wrote: Hi Dave, Thanks for your answer - it solves the problem. In this "zero" a characteristic of Excel? Don't remember it coming up before. Thanks, Phil "Dave Peterson" wrote: =if('Objective C1'!av21="","",'objective c1'!av21) is one way. Phil Hageman wrote: In worksheet 'Strategy Map,' cell K7 has link formual ='Objective C1'!AV21. In worksheet 'Objective C1,' cell AV21 is blank; however, K7 holds a zero. The format for both cells is percent, but even changing them to text does not change the zero value in K7. How do I get K7 to be blank? Thanks, Phil -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show or blank out a cell dependant on an selection in another cell | Excel Discussion (Misc queries) | |||
| Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
| Using paste link infromation in cell to hyperlink to source cell? | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Programming | |||
![Phil Hageman[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
