Summing columns

  • Thread starter Thread starter Hazel
  • Start date Start date
H

Hazel

Hi
I have set very simple formulas such as:
=K10*L10%+K10 and
=SUM(M3:M131)

Why is it then that the sum figure at the bottom is
always out by between 2p and 50p if there is a lot of
figures to add up.
Please can anybody help.
Regards.
Hazel
 
Probably because the values you see on the screen are rounded version of the
actual data.
 
Hi
this is not an error but due to the fact that you see values which are
rounded for display in column B but are internally sotred with more
decimals. Try changing your formula to
=ROUND(K10*L10%+K10,2)
 
Hi again
Well what a quick reply.
Much appreciated and my grateful thanks to you all.
Best wishes.
Hazel
 
Back
Top