=IF(B11="","",B11)

Says....if B11 is empty, make this cell look blank, otherwise show the value
from B11.


Gord Dibben Excel MVP

On Thu, 10 Mar 2005 10:25:08 -0800, "cburgess57"
wrote:

Thank you! That did work, however if the answer to the formula is actually
Zero, then it takes that zero away also...any way around this??? Thanks!

"Fredrik Wahlgren" wrote:


"cburgess57" wrote in message
...
I'm trying to find out how to get rid of a zero when a formula is used,
but
there has not been any data entered in that row yet. For example, as
simple
as copying another cell, you put =b11, if nothing has been entered in b11
yet, it shows a zero, but I dont' want it to show anything...

help!

Select Tools|Options. Select the Display tab. There's an option called
zerovalues that should be unchecked. Unfortunately, I have the Swedish
version so it's possible my translation isn't correct.

/Fredrik