Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
http://www.mcgimpsey.com/excel/pennyoff.html
-- Kind Regards, Niek Otten Microsoft MVP - Excel "tankerpilot" wrote in message ... 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. |
#3
|
|||
|
|||
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? "Niek Otten" wrote: http://www.mcgimpsey.com/excel/pennyoff.html -- Kind Regards, Niek Otten Microsoft MVP - Excel "tankerpilot" wrote in message ... 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. |
#4
|
|||
|
|||
pilot
Have a read at Jerry W. Lewis's response at this google search result. http://snipurl.com/d8ex Gord Dibben Excel MVP On Fri, 4 Mar 2005 13:11:02 -0800, "tankerpilot" wrote: 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? "Niek Otten" wrote: http://www.mcgimpsey.com/excel/pennyoff.html -- Kind Regards, Niek Otten Microsoft MVP - Excel "tankerpilot" wrote in message ... 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. |
#5
|
|||
|
|||
Thank you fro the response Gord, but for whatever reason that url will not
open from my IE browser at work. "Gord Dibben" wrote: pilot Have a read at Jerry W. Lewis's response at this google search result. http://snipurl.com/d8ex Gord Dibben Excel MVP On Fri, 4 Mar 2005 13:11:02 -0800, "tankerpilot" wrote: 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? "Niek Otten" wrote: http://www.mcgimpsey.com/excel/pennyoff.html -- Kind Regards, Niek Otten Microsoft MVP - Excel "tankerpilot" wrote in message ... 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. |
#6
|
|||
|
|||
Try this one...watch out for word-wrap. All one line.
http://groups-beta.google.com/group/...c32309fd9f49ff Gord On Wed, 9 Mar 2005 12:41:03 -0800, "tankerpilot" wrote: Thank you fro the response Gord, but for whatever reason that url will not open from my IE browser at work. "Gord Dibben" wrote: pilot Have a read at Jerry W. Lewis's response at this google search result. http://snipurl.com/d8ex Gord Dibben Excel MVP On Fri, 4 Mar 2005 13:11:02 -0800, "tankerpilot" wrote: 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? "Niek Otten" wrote: http://www.mcgimpsey.com/excel/pennyoff.html -- Kind Regards, Niek Otten Microsoft MVP - Excel "tankerpilot" wrote in message ... 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. |
#7
|
|||
|
|||
Thank you Gord! Url worked and it made sense. Regards
"Gord Dibben" wrote: Try this one...watch out for word-wrap. All one line. http://groups-beta.google.com/group/...c32309fd9f49ff Gord On Wed, 9 Mar 2005 12:41:03 -0800, "tankerpilot" wrote: Thank you fro the response Gord, but for whatever reason that url will not open from my IE browser at work. "Gord Dibben" wrote: pilot Have a read at Jerry W. Lewis's response at this google search result. http://snipurl.com/d8ex Gord Dibben Excel MVP On Fri, 4 Mar 2005 13:11:02 -0800, "tankerpilot" wrote: 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? "Niek Otten" wrote: http://www.mcgimpsey.com/excel/pennyoff.html -- Kind Regards, Niek Otten Microsoft MVP - Excel "tankerpilot" wrote in message ... 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. |
#8
|
|||
|
|||
The original tinyurl did not work for either, but does now.
Go figure! Gord On Thu, 10 Mar 2005 05:31:03 -0800, "tankerpilot" wrote: Thank you Gord! Url worked and it made sense. Regards "Gord Dibben" wrote: Try this one...watch out for word-wrap. All one line. http://groups-beta.google.com/group/...c32309fd9f49ff Gord On Wed, 9 Mar 2005 12:41:03 -0800, "tankerpilot" wrote: Thank you fro the response Gord, but for whatever reason that url will not open from my IE browser at work. "Gord Dibben" wrote: pilot Have a read at Jerry W. Lewis's response at this google search result. http://snipurl.com/d8ex Gord Dibben Excel MVP On Fri, 4 Mar 2005 13:11:02 -0800, "tankerpilot" wrote: 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? "Niek Otten" wrote: http://www.mcgimpsey.com/excel/pennyoff.html -- Kind Regards, Niek Otten Microsoft MVP - Excel "tankerpilot" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing problems with columns and rows | Excel Discussion (Misc queries) | |||
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
Convert multiple columns to rows | Excel Worksheet Functions | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
sumif columns and rows | Excel Worksheet Functions |