|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 28th, 2007, 08:20 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can surplus decimals be omitted when adding derived figures?
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? 
|
|
#2
December 28th, 2007, 08:29 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can surplus decimals be omitted when adding derived figures?
Either use a helper column =ROUND(A2,2) and total those, or
Tools/ Options/ Calculation/ Precision as displayed [but be careful if you choose this latter option, as you may get unexpected results elsewhere.] -- David Biddulph "DBB9" wrote in message ... 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?
|
|
#3
December 28th, 2007, 11:53 PM
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 | |
| Display Modes | |
|
|
Linear Mode
