| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
incorrect calculations
I have created a worksheet with 4 columns...Price per visit, Tax rate, Tax
amount and Total amount. I have set up the formulas to calculate Tax Amount and Total Amount. Those columns are formatted for currency. When I total the tax amount column, it come up 2 cents off. Wouldn't the summing of that column only add by the 2 decimals that it is displaying? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why are the calculations incorrect in my spreadsheet? | Excel Worksheet Functions | |||
| time sum incorrect | Excel Worksheet Functions | |||
| Incorrect Am and Pm | Excel Discussion (Misc queries) | |||
| Incorrect Sum | Excel Discussion (Misc queries) | |||
| Incorrect Sum | Excel Discussion (Misc queries) | |||
Threaded Mode
