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

  • Thread starter Thread starter excelinSD
  • Start date Start date
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
 
Do it this way:

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

Hope this helps.

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