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