Summing columns

[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

 

[Dave R.]

Probably because the values you see on the screen are rounded version of the
actual data.

 

[Frank Kabel]

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)

 

[JE McGimpsey]

take a look here:

http://www.mcgimpsey.com/excel/pennyoff.html

 

[Dave R.]

That's twice in one day!

take a look here:

http://www.mcgimpsey.com/excel/pennyoff.html

 

[Guest]

Hi again
Well what a quick reply.
Much appreciated and my grateful thanks to you all.
Best wishes.
Hazel