| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rounding error
My database in Access 2003 has a form which calculates Quantity by the Price
in the footer which is then multiplied by a Tax rate of 12.5% and the two added to get a Total . I get the following figures in the form Subtotal: 96,738.67 Tax: 12,092.33 TOTAL: 108,831.01. The correct answer should be 108,831.00. I have tried various formats (currency, standard, fixed with rounding Auto & 2) but am not able to correct for that small difference. Any solutions |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My rounding error in a simple IF | Excel Worksheet Functions | |||
| rounding error? | Excel Discussion (Misc queries) | |||
| Rounding error is conditional on brackets | Excel Discussion (Misc queries) | |||
| Have Excel display an error rather than rounding # to fit column | Setting up and Configuration of Excel | |||
| Percentage rounding error in charts | Excel Discussion (Misc queries) | |||
Threaded Mode
