Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pasting formulas with references to other worksheets | Excel Worksheet Functions | |||
References to worksheets in formulae | Excel Discussion (Misc queries) | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
references | Excel Discussion (Misc queries) | |||
references | Excel Discussion (Misc queries) |