|
| 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
April 10th, 2009, 06:05 PM
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
April 10th, 2009, 06:19 PM
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
April 10th, 2009, 06:59 PM
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
April 11th, 2009, 08:45 AM
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
April 13th, 2009, 07:49 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
