Problems

  • Thread starter Thread starter Steven Ridley
  • Start date Start date
S

Steven Ridley

Hello Community,

This is probably a simple thing I want to do, but it is
giving me a headache trying to work it out.

What I want to do is if two cells have no entry I want the
resultant cell to be blank. If either of the two cells
have a value in them I would like the resultant cell to be
the sum of these two cells.

Can someone please help me ? The best I get at the moment
is if the two cells have no value the resulting cell fills
with 0.0

Steven.
 
Hi there and thank you very much for your help. The
formula looks simple enough and I must have just been
thinking the wrong way making it difficult and over
complicated.

Steven.
 
Steven Ridley said:
... The best I get at the moment
is if the two cells have no value the resulting cell fills
with 0.0
Click to expand...

Maybe there might not be a need for the IF() ?

Suppose you're using say, in C1: =SUM(A1:B1)
which is copied down col C ..

You could suppress zeros from showing in the sheet via:
Clicking Tools > Options > View tab > Uncheck "Zero values" > OK

Note that the setting is at worksheet level
so it'll affect all formulas on the sheet which evaluate to zero
(not just those in col C, if there are other formulas elsewhere)
 
Back
Top