| 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 |
| 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)
Threaded Mode
