Remove Zero Formula

[TGalin]

How can I change this formula =SUM(B55) so that it will return a blank cell
instead of a zero if B55 is empty?

 

[Glenn]

How can I change this formula =SUM(B55) so that it will return a blank cell
instead of a zero if B55 is empty?

=IF(your_formula=0,"",your_formula)

 

[Glenn]

How can I change this formula =SUM(B55) so that it will return a blank cell
instead of a zero if B55 is empty?

Or, maybe this:

=IF(COUNT(B55)=0,"",SUM(B55))

 

[Archimedes' Lever]

How can I change this formula =SUM(B55) so that it will return a blank cell
instead of a zero if B55 is empty?

Put it inside an IF statement that tests for it, and returns "" instead
of 0.

 

[UpGrade]

=IF(your_formula=0,"",your_formula)

Exactly.

 

[pomegranate-man]

=IF(your_formula=0,"",your_formula)

If the range might include positive/negative/zero numbers that actually sum
to zero, a zero result would be more informative than an empty-string
result. Another poster suggested a different formula that does this:
=IF(COUNT(B55)=0,"",SUM(B55))

(I know, "picky, picky.")

 

[Glenn]

If the range might include positive/negative/zero numbers that actually sum
to zero, a zero result would be more informative than an empty-string
result. Another poster suggested a different formula that does this:
=IF(COUNT(B55)=0,"",SUM(B55))

(I know, "picky, picky.")

"another poster" = same poster

I had the same thoughts when I re-read the OP's request..."if B55 is empty" is
different than "if B55 equals zero".