Cell calculation

  • Thread starter Thread starter Syd
  • Start date Start date
S

Syd

I have a calculation involving multiple cells (A, B, C, D,
E. if one of those cells ends up having no numeric value,
the resulting #Error. Is there a method for null or ""
values that would prevent this ugly error?

Sample of current formula: =SUM(A1:E1). This formula
generates the above mentioned error.

Any Ideas or Assistance will be appreciated.

Thanks,
 
Syd said:
I have a calculation involving multiple cells (A, B, C, D,
E. if one of those cells ends up having no numeric value,
the resulting #Error. Is there a method for null or ""
values that would prevent this ugly error?

Sample of current formula: =SUM(A1:E1). This formula
generates the above mentioned error.

Any Ideas or Assistance will be appreciated.

Thanks,
Click to expand...

There is no #Error in Excel. There are error values beginning with #. Be
specific about which you get.

=SUM(A1:E1) does not result in an error just because one of the cells
doesn't contain a numeric value. It will cope with blanks and even text
strings.

Please repost, being more accurate in what you say.
 
Paul:

Sorry for not being clearer, here is another example of
what happens Cell D25 has a value, Cell D26 has no value,
in D27 I have a calculation the formula: D25/D26 the
resulting output is the error that follows #Div/0. How do
I get around that. Now the Y column will have this formula
in it =SUM(A27:E27). The result here too is #Div/0, since
D27 is a part of that range being summed in column Y.

Hope this helps explain things a bit better.

Thanks,
 
Yes, that's much clearer. Instead of the formula
=D25/D26
use
=IF(D26="","",D25/D26)
Then you will not get the #DIV/0! error and your subsequent formulas will
work.
 
Paul:

Thanks, for assist!

-----Original Message-----
Yes, that's much clearer. Instead of the formula
=D25/D26
use
=IF(D26="","",D25/D26)
Then you will not get the #DIV/0! error and your subsequent formulas will
work.




.
Click to expand...
 
Back
Top