| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal rounding causing addition errors
We have a spreadsheet we use for bidding our jobs. The summary page has 5
line items that pull from another spreadsheet. Each of those cells are formatted to only show 2 decimal places. However, because one of the items (materials) is a formula result is has 8 decimal places and then only shows 2. Our customer is confused as to why when he manually adds the figures they do not match the total on our sheet. Is there any way to fix this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding errors when a "5" is the third decimal place using formul | Excel Discussion (Misc queries) | |||
| Addition of cells involving rounding | Excel Discussion (Misc queries) | |||
| conditional forming causing linking errors | Excel Worksheet Functions | |||
| sumproduct causing memory errors? | Excel Worksheet Functions | |||
| large sumproducts causing memory errors | Excel Discussion (Misc queries) | |||
Threaded Mode
