A B C

D

1 69,500.00 156,800.00 141,108.00 367,408.00

2 100,857.90 110,228.80 89,602.96 300,689.66

3 13,273.88 53,709.90 - 66,983.78

4 (44,631.78) (7,138.70) 51,505.04 (265.44)

A1-A2-A3=A4, B1-B2-B3=B4, C1-C2-C3=C4

A4+B4+C4=D4

When I add a check formula to verify that (D1-D2-D3=D4)=D4 I get an error

message. I found that although there are not an additional numbers beyond

the 2 decimal places seen in each cell, when I extend the decimal places of

C4 out to about 13 it shows 265.44000000000200 and D1-D2-D3=

265.44000000003100.

What is causing these decimal problems? The numbers in cells A1 thru C3

were typed in just as shown above with at most two decimal points.

Thanks for the quick response. I have read the item cited, however, I do not

understand how this can be a rounding problem in the first place since the

numbers were entered with no more than two decimal places and only simple

addition or subtraction was applied. How can I then end up with a sum that

has some arbitrary decimal number out to 13 or 14 decimal places? There was

no division done or percentages or anything else that would introduce the

results stated in the original post. What am I missing?

understand how this can be a rounding problem in the first place since the

numbers were entered with no more than two decimal places and only simple

addition or subtraction was applied. How can I then end up with a sum that

has some arbitrary decimal number out to 13 or 14 decimal places? There was

no division done or percentages or anything else that would introduce the

results stated in the original post. What am I missing?

pilot

Have a read at Jerry W. Lewis's response at this google search result.

http://www.yqcomputer.com/

Gord Dibben Excel MVP

On Fri, 4 Mar 2005 13:11:02 -0800, "tankerpilot"

Have a read at Jerry W. Lewis's response at this google search result.

http://www.yqcomputer.com/

Gord Dibben Excel MVP

On Fri, 4 Mar 2005 13:11:02 -0800, "tankerpilot"

Thank you fro the response Gord, but for whatever reason that url will not

open from my IE browser at work.

open from my IE browser at work.

Try this one...watch out for word-wrap. All one line.

http://www.yqcomputer.com/ :*Excel*+author:jerry+author:lewis#a7c32309fd9f49ff

Gord

On Wed, 9 Mar 2005 12:41:03 -0800, "tankerpilot"

http://www.yqcomputer.com/ :*Excel*+author:jerry+author:lewis#a7c32309fd9f49ff

Gord

On Wed, 9 Mar 2005 12:41:03 -0800, "tankerpilot"

hank you Gord! Url worked and it made sense. Regards

"Gord Dibben" wrote:

"Gord Dibben" wrote:

he original tinyurl did not work for either, but does now.

Go figure!

Gord

On Thu, 10 Mar 2005 05:31:03 -0800, "tankerpilot"

< XXXX@XXXXX.COM > wrote:

Go figure!

Gord

On Thu, 10 Mar 2005 05:31:03 -0800, "tankerpilot"

< XXXX@XXXXX.COM > wrote:

1. summing columns in repeating table - only sums first row

2. Cumulative summing: sum rows 1-12, then rows 1-24, 1-36, etc..

3. Sum Function - sum option not available for column of numbers

4. Select Sum(table1.column), Sum(table2.column)

5. How to add previous sums in a column to current sums in a column?

6. How to make sum of columns in 1 row be starting point for next row

7. Excel 2000 formula to dynamically sum adjacent rows and columns where rows inserted/deleted

8. How to perform sum sum sum...

9. SUM rows in column if cell in different column is empty

10. Sum sum sum

11. SUM(ADDRESS(ROW(C2),COLUMN(C2),1,TRUE):ADDRESS(C14+1,COLUMN(C2),1,

12. SUM(ADDRESS(ROW(C2),COLUMN(C2),1,TRUE):ADDRESS(C14+1,COLUMN(C2

13. Sum the rows of a column that have the same value in another column

14. summing values in each record (summing across rows)

15. Col sum and Row sum of an array

8 post • Page:**1** of **1**