View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kamran Kamran is offline
external usenet poster
 
Posts: 19
Default References between worksheets using IF

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)