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

Payment calculation 1
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Functions referencing a different workbook 1
returning blank when reference cell is blank 4
linked workbook cell returns 0 is source workbook cell is blank? 4
Hiding a cell with a formula. 2
Getting text or numerical data from the formula 2
Need formulas for searching for a value in a table and returning row/column name 7

Top