linked workbook cell returns 0 is source workbook cell is blank?

S

Syd

EXCEL 2003 - If source workbook cells are blank, some cells are general and
some are number, how come the linked workbook cells returns 0 insteand of
blank. How do I fix this? Thanks
 
G

Gary''s Student

Works the same way even within a worksheet, use:

=IF(A1="","",A1)
rather than
=A1
 
S

Syd

I used the following and it still returns a 0 value

=IF('MRR Form-2'!L1=" "," ",'MRR Form-2'!L1)
 
D

driller

remove the space between " ".
=IF('MRR Form-2'!L1=" "," ",'MRR Form-2'!L1)
Click to expand...

into

=IF('MRR Form-2'!L1="","",'MRR Form-2'!L1)
or
=IF('MRR Form-2'!L1=""," ",'MRR Form-2'!L1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I link a cell in a workbook? 1
Link To File That No Longer Exists 1
Index Match & #values 0
Copy cells in Excel 1
If Not blank - Formula for two cells 0
Peculiar default cell format 1
Evaluate Multiple Cells for any Value 1
Pasting a cell into bookmarked table from excel vba 1

Top