Zero in cell where it is linked to a blank cell - repost

[texansgal]

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. Some cells will have all letters, some
will have all numbers and some will be mixed...


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.

 

[Bernard Liengme]

Not format but formula
If you replace =PL!A27
with =IF(ISBLANK(PL!A27),"",PL!A27)
then when there is nothing in PL!A27 the cell with the formula will display
nothing - that is ne meaning of "" .... a pair of double quotes with nothing
between them

Please note you do not need the parentheses in =(PL!A27)
best wishes

 

[Jacob Skaria]

=IF(PL!A27="","",PL!A27)

If this post helps click Yes

 

[texansgal]

Thank you so much! I will try these. I am still trying to learn all of this
without going to classes... I just need to understand what the meaning are of
each symbol being used... and why use the "IF" and so on... I have so much to
learn! lol

 

[Jacob Skaria]

Hope this helps

"" denotes blank

=IF (condition=something, what to do if condition is true, what to do if
condition is false)