How to get a linked workbook to return a blank value?

E

excelinSD

I have linked 2 workbooks and one of the columns liked is a date format. How
do I get the linked work book to return a blank if there is not a date typed
into the master workbook.
My formula is below:
='[PROPOSAL LOG.xls]Tracking Log'!$G71
What it gives for blanks:
01/00/00
 
P

Pete_UK

Do it this way:

=IF('[PROPOSAL LOG.xls]Tracking Log'!$G71="","",'[PROPOSAL LOG.xls]
Tracking Log'!$G71)

Hope this helps.

Pete
 
S

Sean Timmons

=if('[PROPOSAL LOG.xls]Tracking Log'!$G71=0,"",'[PROPOSAL LOG.xls]Tracking
Log'!$G71)
 

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

Cells linked to another workbook with a formula. 1
Linked sheets, blank cells and adding new rows 1
returning blank when reference cell is blank 4
Default display of sample date in linked workbook with blank date in source cell 2
Sumif linked to different workbook 1
How to get largest date from a Vlookup 1
Linked date field in worksheet defaults a blank field as 1/0/1900 2
linked workbook (cells) does not show entire length of original te 2

Top