# Remove Zero Formula

T

#### TGalin

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

G

#### Glenn

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

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

G

#### Glenn

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

Or, maybe this:

=IF(COUNT(B5 5)=0,"",SUM(B5 5))

A

#### Archimedes' Lever

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

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

U

P

#### pomegranate-man

TGalin said:
=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(B5 5)=0,"",SUM(B5 5))

(I know, "picky, picky.")

G

#### Glenn

pomegranate-man said:
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(B5 5)=0,"",SUM(B5 5))

(I know, "picky, picky.")

"another poster" = same poster

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