=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