| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linked workbook cell returns 0 is source workbook cell is blank?
EXCEL 2003 - If source workbook cells are blank, some cells are general and
some are number, how come the linked workbook cells returns 0 insteand of blank. How do I fix this? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linked workbook cell returns 0 is source workbook cell is blank?
Works the same way even within a worksheet, use:
=IF(A1="","",A1) rather than =A1 -- Gary''s Student - gsnu200845 "Syd" wrote: EXCEL 2003 - If source workbook cells are blank, some cells are general and some are number, how come the linked workbook cells returns 0 insteand of blank. How do I fix this? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linked workbook cell returns 0 is source workbook cell is blan
I used the following and it still returns a 0 value
=IF('MRR Form-2'!L1=" "," ",'MRR Form-2'!L1) "Gary''s Student" wrote: Works the same way even within a worksheet, use: =IF(A1="","",A1) rather than =A1 -- Gary''s Student - gsnu200845 "Syd" wrote: EXCEL 2003 - If source workbook cells are blank, some cells are general and some are number, how come the linked workbook cells returns 0 insteand of blank. How do I fix this? Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linked workbook cell returns 0 is source workbook cell is blan
remove the space between " ".
=IF('MRR Form-2'!L1=" "," ",'MRR Form-2'!L1) into =IF('MRR Form-2'!L1="","",'MRR Form-2'!L1) or =IF('MRR Form-2'!L1=""," ",'MRR Form-2'!L1) "Syd" wrote: I used the following and it still returns a 0 value =IF('MRR Form-2'!L1=" "," ",'MRR Form-2'!L1) "Gary''s Student" wrote: Works the same way even within a worksheet, use: =IF(A1="","",A1) rather than =A1 -- Gary''s Student - gsnu200845 "Syd" wrote: EXCEL 2003 - If source workbook cells are blank, some cells are general and some are number, how come the linked workbook cells returns 0 insteand of blank. How do I fix this? Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linked workbook cell returns 0 is source workbook cell is blan
"driller" wrote: remove the space between " ". =IF('MRR Form-2'!L1=" "," ",'MRR Form-2'!L1) into =IF('MRR Form-2'!L1="","",'MRR Form-2'!L1) or =IF('MRR Form-2'!L1=""," ",'MRR Form-2'!L1) "Syd" wrote: I used the following and it still returns a 0 value =IF('MRR Form-2'!L1=" "," ",'MRR Form-2'!L1) "Gary''s Student" wrote: Works the same way even within a worksheet, use: =IF(A1="","",A1) rather than =A1 -- Gary''s Student - gsnu200845 "Syd" wrote: EXCEL 2003 - If source workbook cells are blank, some cells are general and some are number, how come the linked workbook cells returns 0 insteand of blank. How do I fix this? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get a linked workbook to return a blank value? | Excel Worksheet Functions | |||
| sumif returns #VALUE! when linked workbook is closed | Excel Worksheet Functions | |||
| pulling color from cell of workbook to another linked workbook | Excel Discussion (Misc queries) | |||
| Find which cell is linked to another workbook | Excel Discussion (Misc queries) | |||
| Creating Linked Workbook file name using cell variables | Excel Worksheet Functions | |||
![Syd[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
