Return Blank instead of Zero

[Db1712]

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

 

[tralls]

Use =IF(E6,E6,"") versus =E6

 

[Guest]

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

 

[Guest]

Hi
this won't work if E6 contains a text value

 

[Guest]

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.

 

[Ken Wright]

Try this

=IF(B1=0,"",B1)

Will return "" if B1 is blank or has a zero.

 

[Tom Ogilvy]

Define how you make a grphic with your new values.

 

[RagDyeR]

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!
==============================================


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.

 

[Guest]

Yes Sir, it works, thanks

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!
==============================================


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.

 

[Ragdyer]

Appreciate the feed-back.