Remove Zero Formula


T

TGalin

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

Advertisements

G

Glenn

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

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

Glenn

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


Or, maybe this:

=IF(COUNT(B5:D5)=0,"",SUM(B5:D5))
 
A

Archimedes' Lever

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


Put it inside an IF statement that tests for it, and returns "" instead
of 0.
 
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:D5)=0,"",SUM(B5:D5))

(I know, "picky, picky.")
 
Ad

Advertisements

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

(I know, "picky, picky.")


"another poster" = same poster

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top