Zero in cell where it is linked to a blank cell

  • Thread starter Thread starter texansgal
  • Start date Start date
T

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 said:
=IF(A1="","",A1)
Click to expand...

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).
 
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.
 
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?
 
=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
 
Back
Top