Zero in cell where it is linked to a blank cell
 

When I enter a formula to link a cell to another cell, the cell that is
copied from the other cell has a ZERO when the linked cell is blank.

What is the format I should use for this to not happen when there are
letters as well as numbers?

Thank you,
Vanessa

Zero in cell where it is linked to a blank cell
 

=IF(A1="","",A1)
--
Gary''s Student - gsnu200838

Zero in cell where it is linked to a blank cell
 

"Gary''s Student" wrote:

=IF(A1="","",A1)

While that formula will display a blank cell, the cell is not truly blank,
as the ISBLANK function returns FALSE, and a graph plots a zero value. I need
the cell to be truly blank (the ISBLANK function should return TRUE).

Zero in cell where it is linked to a blank cell
 

If you want a blank cell, don't put anything in it.
A formula cannot return a truly blank result.
I you want a chart not to plot as zero, put NA() in the formula instead of
"".
--
David Biddulph

jgenzano wrote:
"Gary''s Student" wrote:

=IF(A1="","",A1)

While that formula will display a blank cell, the cell is not truly
blank, as the ISBLANK function returns FALSE, and a graph plots a
zero value. I need the cell to be truly blank (the ISBLANK function
should return TRUE).

Zero in cell where it is linked to a blank cell
 

I have a cell on one sheet in a workbook as =(PL!A27) which is the sheet and
the cell being referenced. I want cell AF1, sheet BOL to automatically fill
in when something is typed into the Cell A27 on the sheet named PL. However
when there is nothing in cell A27, sheet PL, cell AF1, sheet BOL has a Zero
until something is entered into that cell... so what format can I use for all
of the cells being linked to another.


A question off this topic... does anyone know how to pull up all of my old
questions on here? I looked in my profile and didn't see anything. I could be
overlooking it.


"texansgal" wrote:

When I enter a formula to link a cell to another cell, the cell that is
copied from the other cell has a ZERO when the linked cell is blank.

What is the format I should use for this to not happen when there are
letters as well as numbers?

Thank you,
Vanessa

Zero in cell where it is linked to a blank cell
 

Hi Texansgal
Not sure if this is what you want, this will keep the cell empty if there's
nothing in AF1
=if(BOL!AF1="","",PL!A27
Your second question, go the link below and type your e.mail address.
http://groups.google.com/groups/profile?enc_user=

HTH
John
Cheers from Montreal,Canada
"texansgal" wrote in message
...
I have a cell on one sheet in a workbook as =(PL!A27) which is the sheet and
the cell being referenced. I want cell AF1, sheet BOL to automatically fill
in when something is typed into the Cell A27 on the sheet named PL. However
when there is nothing in cell A27, sheet PL, cell AF1, sheet BOL has a Zero
until something is entered into that cell... so what format can I use for all
of the cells being linked to another.


A question off this topic... does anyone know how to pull up all of my old
questions on here? I looked in my profile and didn't see anything. I could be
overlooking it.


"texansgal" wrote:

When I enter a formula to link a cell to another cell, the cell that is
copied from the other cell has a ZERO when the linked cell is blank.

What is the format I should use for this to not happen when there are
letters as well as numbers?

Thank you,
Vanessa

Zero in cell where it is linked to a blank cell
 

Oops
Correction..
=IF(PL!A27="","",PL!A27
"John" wrote in message
...
Hi Texansgal
Not sure if this is what you want, this will keep the cell empty if there's
nothing in AF1
=if(BOL!AF1="","",PL!A27
Your second question, go the link below and type your e.mail address.
http://groups.google.com/groups/profile?enc_user=

HTH
John
Cheers from Montreal,Canada
"texansgal" wrote in message
...
I have a cell on one sheet in a workbook as =(PL!A27) which is the sheet and
the cell being referenced. I want cell AF1, sheet BOL to automatically fill
in when something is typed into the Cell A27 on the sheet named PL. However
when there is nothing in cell A27, sheet PL, cell AF1, sheet BOL has a Zero
until something is entered into that cell... so what format can I use for all
of the cells being linked to another.


A question off this topic... does anyone know how to pull up all of my old
questions on here? I looked in my profile and didn't see anything. I could be
overlooking it.


"texansgal" wrote:

When I enter a formula to link a cell to another cell, the cell that is
copied from the other cell has a ZERO when the linked cell is blank.

What is the format I should use for this to not happen when there are
letters as well as numbers?

Thank you,
Vanessa

Zero in cell where it is linked to a blank cell
 

Right now, I have a formula in the cell (we'll say B2 on Sheet 2) to have the
same information as cell B2 on Sheet 1. There is no information entered in
the cell B2 on Sheet 1 therefore it has a 0 showing up in cell B2 on Sheet 2.

Does this make anymore sense?

Would I have my formula to link it and then add the =IF(PL!A27="","",PL!A27
that you gave me for this?





"John" wrote:

Oops
Correction..
=IF(PL!A27="","",PL!A27
"John" wrote in message
...
Hi Texansgal
Not sure if this is what you want, this will keep the cell empty if there's
nothing in AF1
=if(BOL!AF1="","",PL!A27
Your second question, go the link below and type your e.mail address.
http://groups.google.com/groups/profile?enc_user=

HTH
John
Cheers from Montreal,Canada
"texansgal" wrote in message
...
I have a cell on one sheet in a workbook as =(PL!A27) which is the sheet and
the cell being referenced. I want cell AF1, sheet BOL to automatically fill
in when something is typed into the Cell A27 on the sheet named PL. However
when there is nothing in cell A27, sheet PL, cell AF1, sheet BOL has a Zero
until something is entered into that cell... so what format can I use for all
of the cells being linked to another.


A question off this topic... does anyone know how to pull up all of my old
questions on here? I looked in my profile and didn't see anything. I could be
overlooking it.


"texansgal" wrote:

When I enter a formula to link a cell to another cell, the cell that is
copied from the other cell has a ZERO when the linked cell is blank.

What is the format I should use for this to not happen when there are
letters as well as numbers?

Thank you,
Vanessa

Zero in cell where it is linked to a blank cell
 

=IF(Sheet1!B2="","",Sheet1!B2) is all you need in B2 of Sheet2

Does the linking and handles the zero.

=IF(PL!A27="","",PL!A27) is exactly the same construct.

It would be used in place of =PL!A27 which you currently have.


Gord Dibben MS Excel MVP


On Mon, 1 Jun 2009 12:46:02 -0700, texansgal
wrote:

Right now, I have a formula in the cell (we'll say B2 on Sheet 2) to have the
same information as cell B2 on Sheet 1. There is no information entered in
the cell B2 on Sheet 1 therefore it has a 0 showing up in cell B2 on Sheet 2.

Does this make anymore sense?

Would I have my formula to link it and then add the =IF(PL!A27="","",PL!A27
that you gave me for this?





"John" wrote:

Oops
Correction..
=IF(PL!A27="","",PL!A27
"John" wrote in message
...
Hi Texansgal
Not sure if this is what you want, this will keep the cell empty if there's
nothing in AF1
=if(BOL!AF1="","",PL!A27
Your second question, go the link below and type your e.mail address.
http://groups.google.com/groups/profile?enc_user=

HTH
John
Cheers from Montreal,Canada
"texansgal" wrote in message
...
I have a cell on one sheet in a workbook as =(PL!A27) which is the sheet and
the cell being referenced. I want cell AF1, sheet BOL to automatically fill
in when something is typed into the Cell A27 on the sheet named PL. However
when there is nothing in cell A27, sheet PL, cell AF1, sheet BOL has a Zero
until something is entered into that cell... so what format can I use for all
of the cells being linked to another.


A question off this topic... does anyone know how to pull up all of my old
questions on here? I looked in my profile and didn't see anything. I could be
overlooking it.


"texansgal" wrote:

When I enter a formula to link a cell to another cell, the cell that is
copied from the other cell has a ZERO when the linked cell is blank.

What is the format I should use for this to not happen when there are
letters as well as numbers?

Thank you,
Vanessa