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. |
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 |