LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
tankerpilot
 
Posts: n/a
Default Sum of rows does not tie to sum of columns

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing problems with columns and rows Ann Shaw Excel Discussion (Misc queries) 0 February 17th 05 05:35 PM
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. JamesR Excel Discussion (Misc queries) 3 January 12th 05 02:18 PM
Convert multiple columns to rows Lois Lane Excel Worksheet Functions 8 January 10th 05 12:47 AM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 05:40 PM
sumif columns and rows Paul Clough Excel Worksheet Functions 2 November 22nd 04 05:01 PM


All times are GMT +1. The time now is 04:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"