Sum of rows does not tie to sum of columns

Sum of rows does not tie to sum of columns

Post by dGFua2VycG » Sun, 06 Mar 2005 05:37:03



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.
 
 
 

Sum of rows does not tie to sum of columns

Post by Niek Otte » Sun, 06 Mar 2005 05:56:35

http://www.yqcomputer.com/

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 
 
 

Sum of rows does not tie to sum of columns

Post by dGFua2VycG » Sun, 06 Mar 2005 06:11:02

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?
 
 
 

Sum of rows does not tie to sum of columns

Post by Gord Dibbe » Sun, 06 Mar 2005 08:05:06

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"
 
 
 

Sum of rows does not tie to sum of columns

Post by dGFua2VycG » Fri, 11 Mar 2005 05:41:03

Thank you fro the response Gord, but for whatever reason that url will not
open from my IE browser at work.
 
 
 

Sum of rows does not tie to sum of columns

Post by Gord Dibbe » Fri, 11 Mar 2005 10:44:34

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"
 
 
 

Sum of rows does not tie to sum of columns

Post by dGFua2VycG » Fri, 11 Mar 2005 22:31:03

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

"Gord Dibben" wrote:

 
 
 

Sum of rows does not tie to sum of columns

Post by Gord Dibbe » Sat, 12 Mar 2005 06:56:23

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: