A correct formula gives an incorrect figure
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
"GarMcCas" wrote:
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.
|