Formula incorrectly calculating

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

Hi,
I noticed that a couple of formulas in the same
spreadsheet were incorrectly calculating. The formulas
were correct but the results were incorrect. I cleared
the cells and re-entered the formulas exactly as they
were before, but then the formulas wouldn't calculate at
all. I checked to make sure that the formulas were set
for automatic calculation, which they were. What could
be going on?
 
Hi
you may post some more details:
- your formula
- the wrong result
- the expected result
- etc.
 
--

I am having the same problem.

Here is the sum

£34.40
£6.02
£40.43


I have tried both formula's

=SUM(H9:H10) and =SUM(H9+H10)

Thanks for any help
 
Frank Kabel wrote...
and what was your (wrong) result?
Click to expand...

Bad job of snipping, Frank.

From Geoff:

"I am having the same problem.

Here is the sum

£34.40
£6.02
£40.43


I have tried both formula's

=SUM(H9:H10) and =SUM(H9+H10)"

I'd bet these are

H9: £34.40
H10: £6.02
H11: £40.43

where H11 contains either of the OP's formulas, =SUM(H9:H10) or
=SUM(H9+H10).

NOTE FOR GEOFF: don't use =SUM(x+y), there's no point in calling SUM;
just use =x+y.

Now as for the problem, this is almost certainly due to rounding error.
If H9:H11 were all *formatted* to 2 decimal places, that won't affect
the *values* in any of those cells, just how they're displayed. If the
*value* in H9 were 34.404, it'd round to 2 places as 34.40. If the
*value* of H10 were 6.023, it'd round to 2 places as 6.02. If you
summed them, the *value* would be 40.427, but that rounds to 2 places
as 40.43.

Either round the values in cells H9 and H10, or total their rounded
values, e.g., in H11

=SUMPRODUCT(ROUND(H9:H10,2))
 
Thank you for your help. That has sorted the problem out

Geoff


Frank Kabel said:
[...]
Frank Kabel wrote...

Bad job of snipping, Frank.
Click to expand...

Hi Harlan
Indeed. Should have recognized that. Probably too late to see somethng
so simple :-)

Frank
Click to expand...
 
Back
Top