Also take out the space before ""'s and = and the second 'Active ' thus:
=IF('Active '!B18="","",'Active '!B18)
The formula still works with them there, but they are not necessary.

Philip

Pete_UK wrote:
You are missing a space after the second Active:

=IF('Active '!B18 = "", "", 'Active '!B18)

Of course, B18 might actually contain a zero!

Hope this helps.

Pete

On Feb 23, 8:19 pm, Kamran wrote:

Hello,
I'm trying to using cross-references between different worksheets within an
Excel document. Using a Paste Link, I get something like this:

'Active '!B18

The problem is that any empty cells show up as "0" in the target. So I
tried using an IF statement, but it doesn't seem to work. What I want it to
do is show the result only if there is something in the source cell,
otherwise not display anything. Is there a problem with the syntax?

=IF('Active '!B18 = "", "", 'Active'!B18)