If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|