A correct formula gives an incorrect figure

[GarMcCas]

In a payrol sheet I am adding a row of numbers calculating the amount paid in
one month. There are 4 numbers all ending in 1. the formula I used to
calculate is a very basic formula. It is =SUM(G10:G14). Instead of giving
me the last number as 4, it gives me a 5.

 

[Franz Verga]

In a payrol sheet I am adding a row of numbers calculating the amount
paid in one month. There are 4 numbers all ending in 1. the formula
I used to calculate is a very basic formula. It is =SUM(G10:G14).
Instead of giving me the last number as 4, it gives me a 5.

Maybe the numbers have also a decimal hidden part...



--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[Michael M]

Hi
In that case it must be rounding !!
Have a look at your data to be summed and see if it is calculating to more
decimal places than appears on the screen by formatting the cell that is
giving you the wrong answer and see if it is formatted to enough decimal
places

HTH
Michael M

 

[salut]

Like 1.2+1.3+1.2+1.2=4.9
Or what you see is 1+1+1+1=5.

 

[GarMcCas]

I did find the error, there were numbers not showing, I went into options on
the tools area and checked calculations, and clicked precision as displayed