Excel is not adding up figures correctly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cannot get sums to add up correctly. Whenever I have the sum of few cells
being multiplied by a certain amount, the answer is off by a few decimal
points. It is driving me mad. Please help.
 
You may simply need to display more decimal points to be certain what is
being multiplied. Try showing 5/6 decimal places in all your cells .

Can you give an example?
 
You must log in or register to reply here.

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

Similar Threads

why is answer rounded up? 1
Adding Incorrectly - off by 1 penny 5
Rounding Effecting Sum 2
Numbers showing Up Centered in Cell ? 1
Pivot Table Formula not multiplying correctly 2
If function not working correctly 15
simple formula help in Excel 2007 2
How do I 'SUM' a column corrected to 2 decimal places from 3 2

Back
Top