Zero in cell where it is linked to a blank cell

[texansgal]

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

 

[Gary''s Student]

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

 

[jgenzano]

=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).

 

[John]

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

 

[John]

Oops
Correction..
=IF(PL!A27="","",PL!A27

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]

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?

 

[Gord Dibben]

=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