How do you add up the numbers right???

**eman7209** · 11-18-2011, 08:55 PM

ok if you take a look at the spreadsheet and next to the grey square on that amount it should be 402.42, BUT it comes out to 402.21. When i use a calculator it comes out to 402.22 is there away so it would come out right? need help please thanks

**JieJenn** · 11-18-2011, 09:11 PM

I looked at the file and I do not understand your question. None of the cell contain a formula.

**Marcol** · 11-18-2011, 09:16 PM

Either get a new calculator, or tell us what the formula in H9 is ...

$461.58 might be another possibility,or even $402.42 ...

Try in H9

Please Login or Register  to view this content.

Drag Up and Down as required

**eman7209** · 11-19-2011, 08:00 PM

Ok here is the formulas they are the same, but where its 402.21, it should be 402.22 why is that??? the others are correct... that is the only one i want to fix. please let me know thanks

**shg** · 11-19-2011, 08:05 PM

Values look fine to me:

Please Login or Register  to view this content.

**teylyn** · 11-20-2011, 05:02 AM

Hello,

if you're after precision at the second digit after the comma, then you may want to pay some attention to the numbers you post.

What exactly do you calculate to arrive at 402.22?

That's obviously a typo, right? Details matter.

Now, take a second look at your worksheet and display more than just two decimals, for example show all decimals. Enter these into your calculator again.

The result will be 402.412.

Excel takes into account ALL decimals when calculating the result. The difference is due to the fact that you entered numbers with only two decimals into the calculator, e.g. you entered

432.00 - 18.14 - 0.00 - 0.00 - 6.26 - 5.18 = 402.42

The numbers actually stored in the cells, though, are

432.000 - 18.144 - 0.000 - 0.000 - 6.264 - 5.180 = ??

See the difference? Enter them into your calculator with all three decimals. What does that compute?