Yes Sir, it works, thanks

"RagDyeR" wrote:

The #N/A error message will allow your graph to *not* show zeroes.

=IF(OR(B1={"",0}),#N/A,B1)


HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Enrique Porras" <Enrique wrote in message
...
Hi, I have the same problem with blanks and ceros in cells. I want to make
calculations from blank cells then I used =If (B2="","",B2-1), the problem
is
that when I make a graphic with my new values, cero appears in the graphic.

"Frank Kabel" wrote:

Hi
=IF(B1="","",B1)

"Db1712" wrote:


I have two cells linked, is there a formatting to return a blank
instead of zero when the cell its linked to is empty


--
Db1712
------------------------------------------------------------------------
Db1712's Profile:
http://www.excelforum.com/member.php...o&userid=15912
View this thread:
http://www.excelforum.com/showthread...hreadid=314201