Sum display error - Can explain why the rounding error Happens

[jbukovatz]

SumDisplayError.xlsx
			C	D	E	F	G	H	I	J	K	L	M
2			Decrease	Increase		Balance
3			$37.75			$2,438.34
4			$117.37			$2,320.97
5				850.00		$3,170.97
6			$16.38			$3,154.59
7			$28.19			$3,126.40			Decrease	Increase	Balance from row above	Cal. Balance
8			$311.25			$2,815.15000000000			$311.250000000000000	$0.000000000000000	$3,126.400000000000000	$2,815.150000000000000
9				937.00		$3,752.15000000000			$0.000000000000000	$937.000000000000000	$2,815.150000000000000	$3,752.150000000000000
10				1,070.00		$4,822.15000000001		Start Here	$0.000000000000000	$1,070.000000000000000	$3,752.150000000000000	$4,822.150000000010000
11			$42.49			$4,779.66000000001			$42.490000000000000	$0.000000000000000	$4,822.150000000010000	$4,779.660000000010000
12			$50.00			$4,729.66
13				935.00		$5,664.66
14			$3,000.00			$2,664.66		Whole Number	$0.000000000000000	$1,070.000000000000000	$3,752.150000000000000	$4,822.150000000000000
15			$51.37			$2,613.29		Difference	$0.000000000000000	$0.000000000000000	$0.000000000004547	$0.000000000000000	Row 10 - Row14
Test

Cell Formulas
Range	Formula
I8:I11	I8	=TableCkReg[@Decrease]
J8:J11	J8	=TableCkReg[@Increase]
K8:K11	K8	=F7
L8:L11,L14	L8	=+K8+J8-I8
F8:F11	F8	=SUM(F7+D8-C8)
I15:L15	I15	=I10-I14

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C3:F122,I8:L11,I13:L16	Expression	=AND(#REF!<>"",#REF!=ROW())	text	NO
C3:D122	Expression	=ISNUMBER(#REF!)	text	NO
C3:D122	Expression	=DAY(#REF!)>DAY(#REF!)	text	NO

 

[Fluff]

Hi & welcome to MrExcel.
Some numbers simply cannot be accurately stored in binary form. Floating-point arithmetic may give inaccurate result in Excel - Office

 

[Mario_R]

Hello. In 'F8' you have:

=SUM(F7+D8-C8)​

Replace that formula with this:

=ROUND(F7+D8-C8, 2)​

And copy it to the whole column 'F'.