ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel is not adding up figures correctly (https://www.excelbanter.com/excel-discussion-misc-queries/107596-excel-not-adding-up-figures-correctly.html)

Michael

Excel is not adding up figures correctly
 
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.


Toppers

Excel is not adding up figures correctly
 
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?

"Michael" wrote:

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.



All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com