A correct formula gives an incorrect figure

G

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.
 
F

Franz Verga

GarMcCas said:
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
 
M

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top