Posted to microsoft.public.excel.programming
|
|
Can result of formula not display if =0
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 wrote in message
...
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?
|