My formula reads: =SUM(B6+B22+B42+B57)
The Result reads: "0" because there are no values in Cells B6, B22, B42 and
B57 yet.
How can I write the formula so the cell shows no value if it equals zero?

you can try something like the following

=IF(SUM(B6+B22+B42+B57)=0,"",SUM(B6+B22+B42+B57))

if the sum = 0 it puts a blank otherwise it puts the sum total.

it's one workaround

David

"Formula Result to Read No Value-Not Zero" wrote:

> My formula reads: =SUM(B6+B22+B42+B57)
> The Result reads: "0" because there are no values in Cells B6, B22, B42 and
> B57 yet.
> How can I write the formula so the cell shows no value if it equals zero?

You don't need SUM and +, either

=SUM(B6,B22,B42,B57)

or

=B6+B22+B42+B57



--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Formula Result to Read No Value-Not Zero" <Formula Result to Read No
Value-Not (E-Mail Removed)> wrote in message
news:4B3232EA-A3B3-40C2-A7F6-(E-Mail Removed)...
> My formula reads: =SUM(B6+B22+B42+B57)
> The Result reads: "0" because there are no values in Cells B6, B22, B42
> and
> B57 yet.
> How can I write the formula so the cell shows no value if it equals zero?

DKINN: Thank you. This works!

"dkinn" wrote:

> you can try something like the following
>
> =IF(SUM(B6+B22+B42+B57)=0,"",SUM(B6+B22+B42+B57))
>
> if the sum = 0 it puts a blank otherwise it puts the sum total.
>
> it's one workaround
>
> David
>
> "Formula Result to Read No Value-Not Zero" wrote:
>
> > My formula reads: =SUM(B6+B22+B42+B57)
> > The Result reads: "0" because there are no values in Cells B6, B22, B42 and
> > B57 yet.
> > How can I write the formula so the cell shows no value if it equals zero?