Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() I have built a spread sheet that will add individual column of numbers. The last row on each column is the total for that column. (Row 50). The next row (Row 51) is a formula that is as follows: (A50/1.06)*.06 . Row 50 being the Total for each column of numbers. The formula is to take the total for each individual column and divide it by 1.06 then multiply that by .06. I have formatted all numbers in each cell to be (numbers to 2 decimal places). At the end of Row 51 (Lets say Column M) I have added all of the numbers in Row 51. The Total in M51 does not equal the displayed numbers in each of the cells. There is usually .01 to .05 cents difference. I think I know what might be causing this error. It appears to be a rounding error. I do not know how to fix this problem. Any comments or suggestions are much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding numbers or characters to existing numbers | Excel Worksheet Functions | |||
adding + and - numbers | Excel Worksheet Functions | |||
adding odd numbers | Excel Worksheet Functions | |||
Adding numbers... | Excel Discussion (Misc queries) | |||
Adding numbers to current numbers | Excel Worksheet Functions |