| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can surplus decimals be omitted when adding derived figures?
On Dec 28, 12:20*pm, DBB9 wrote:
I have a column of calculated figures, displayed to 2 decimals. When Excel 2003 adds this it includes concealed decimals, creating a rounding error in the total. How can I delete the excess decimals so they do not distort the calculation? If the column of numbers is A1:A100, you could sum them as they appear with the following formula: =sumproduct(round(A1:A100,2)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display figures with thousand omitted | Excel Discussion (Misc queries) | |||
| Need help with Adding Decimals | Excel Worksheet Functions | |||
| Desire Sum to add visible figures rather than underlying decimals | Excel Discussion (Misc queries) | |||
| Adding Decimals | Excel Discussion (Misc queries) | |||
| Adding figures | Excel Worksheet Functions | |||
Threaded Mode
