Error when adding, subtracting inside bracket

  • Thread starter Thread starter turtleman2
  • Start date Start date
T

turtleman2

This simple operation is giving me a #VALUE error-msge, and I can'
figure why:
All I'm trying to do is, sum five adjacent values in a range [sa
B52:B56], subtract a simple value from them [say, "66.53" w/ou
quotes], then multiply the result by .78.
So what I'm inputting is:
=SUM((B52:B56)-(66.53))*.78

And what I'm getting is an error msge. I've already checked to mak
sure all cells are formatted for number, 2 decimal places.
WHAT GIVES???

Thanks in advance for your help [:-)

turtleman2
 
Watch your parentheses:

=SUM((B52:B56)-(66.53))*.78
should be:
=(SUM(B52:B56)-66.53)*.78
(maybe???)

Sum up b52:b56, then subtract, then multiply.

turtleman2 < said:
This simple operation is giving me a #VALUE error-msge, and I can't
figure why:
All I'm trying to do is, sum five adjacent values in a range [say
B52:B56], subtract a simple value from them [say, "66.53" w/out
quotes], then multiply the result by .78.
So what I'm inputting is:
=SUM((B52:B56)-(66.53))*.78

And what I'm getting is an error msge. I've already checked to make
sure all cells are formatted for number, 2 decimal places.
WHAT GIVES???

Thanks in advance for your help [:-)

turtleman2.
Click to expand...
 
To Dave Peterson,

thanks a bunch; that did the trick!
now I'll have to figure out the logic of WHY the sequence yo
suggested made the difference it did....

I appreciate the help, Dave.

turtleman2
 
Based on you question, I think this is what you are asking...
The individual items / numbers need to be separated by commas.

=SUM(B52:B56, -66.53)

vs part of your original formula
=SUM((B52:B56)-(66.53))
Click to expand...

HTH.
Dana DeLouis
 
Back
Top