| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| Nested IF - return a blank when compared cells are blank | New Users to Excel | |||
| How to return a blank formula cell if the reference is blank? | Excel Worksheet Functions | |||
| Return a blank cell instead of a zero value for two linked sheets. | Excel Discussion (Misc queries) | |||
| Sumif to return a blank if sum range is blank | Excel Worksheet Functions | |||
Linear Mode
