ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   The sum amount total does not equal the the individual cells. (https://www.excelbanter.com/excel-discussion-misc-queries/196570-sum-amount-total-does-not-equal-individual-cells.html)

Excel @sum does not equal

The sum amount total does not equal the the individual cells.
 
When you add up the individual cell amounts manually, it is off by a penny. I
checked the rounding format, it seems normal.

Peo Sjoblom[_2_]

The sum amount total does not equal the the individual cells.
 
Where did you round?


http://www.mcgimpsey.com/excel/pennyoff.html

--


Regards,


Peo Sjoblom

"Excel @sum does not equal" <Excel @sum does not
wrote in message
...
When you add up the individual cell amounts manually, it is off by a
penny. I
checked the rounding format, it seems normal.





All times are GMT +1. The time now is 07:47 PM.

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