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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to get a linked workbook to return a blank value? (https://www.excelbanter.com/excel-worksheet-functions/220401-how-get-linked-workbook-return-blank-value.html)

excelinSD

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

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

Pete_UK

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

Do it this way:

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

Hope this helps.

Pete

On Feb 11, 4:42*pm, excelinSD
wrote:
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

Sean Timmons

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

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

"excelinSD" wrote:

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

All times are GMT +1. The time now is 02:13 AM.