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

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

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

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