| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make a X amount equal $300,000 | Excel Discussion (Misc queries) | |||
| Should grand total equal average of sub total | Excel Discussion (Misc queries) | |||
| Should grand total equal average of sub total | Excel Discussion (Misc queries) | |||
| find all employees whose total salaries equal a given amount | Excel Discussion (Misc queries) | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Linear Mode
