Thread
:
Can result of formula not display if =0
View Single Post
#
1
Posted to microsoft.public.excel.programming
Formula Result to Read No Value-Not Zero
external usenet poster
Posts: 1
Can result of formula not display if =0
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?
Reply With Quote
Formula Result to Read No Value-Not Zero
View Public Profile
Find all posts by Formula Result to Read No Value-Not Zero