What is wrong in this.?

[RAJESH1960]

Hello experts,
I am checking to match the balance in column C by a formula in column D and rechecking in column E to confirm. Even if the final balance and balance at each row is matching I am getting a False in majority of the cells in column E. Can someone please tell me what is wrong.?

Book1
	A	B	C	D	E
1	Dr Amount	Cr Amount	Balance	Check	Matched
2	7,500.00		292.56	292.56	TRUE
3		21,000.00	21,292.56	21,292.56	TRUE
4	20,000.00		1,292.56	1,292.56	TRUE
5		780.00	2,072.56	2,072.56	TRUE
6	500.00		1,572.56	1,572.56	TRUE
7		2,150.00	3,722.56	3,722.56	TRUE
8		47,118.00	50,840.56	50,840.56	TRUE
9	30,093.00		20,747.56	20,747.56	TRUE
10	16,750.00		3,997.56	3,997.56	TRUE
11	118.00		3,879.56	3,879.56	TRUE
12		36,545.00	40,424.56	40,424.56	TRUE
13		570.00	40,994.56	40,994.56	TRUE
14		1,580.00	42,574.56	42,574.56	TRUE
15		10,000.00	52,574.56	52,574.56	TRUE
16		300.00	52,874.56	52,874.56	TRUE
17		5,280.00	58,154.56	58,154.56	TRUE
18		25,000.00	83,154.56	83,154.56	TRUE
19	37,233.00		45,921.56	45,921.56	TRUE
20		2,360.00	48,281.56	48,281.56	TRUE
21	10,000.00		38,281.56	38,281.56	TRUE
22	15,000.00		23,281.56	23,281.56	TRUE
23	8,000.00		15,281.56	15,281.56	TRUE
24		2,000.00	17,281.56	17,281.56	TRUE
25		100.00	17,381.56	17,381.56	TRUE
26		17,000.00	34,381.56	34,381.56	TRUE
27	30,000.00		4,381.56	4,381.56	TRUE
28	118.00		4,263.56	4,263.56	TRUE
29		2,755.00	7,018.56	7,018.56	TRUE
30		4,000.00	11,018.56	11,018.56	TRUE
31		20,000.00	31,018.56	31,018.56	TRUE
32	18,000.00		13,018.56	13,018.56	TRUE
33		20,000.00	33,018.56	33,018.56	TRUE
34		3,000.00	36,018.56	36,018.56	TRUE
35		950.00	36,968.56	36,968.56	TRUE
36		2,085.00	39,053.56	39,053.56	TRUE
37	1,000.00		38,053.56	38,053.56	TRUE
38	3,000.00		35,053.56	35,053.56	TRUE
39	18,064.00		16,989.56	16,989.56	TRUE
40		360.00	17,349.56	17,349.56	TRUE
41	10,000.00		7,349.56	7,349.56	TRUE
42		10,000.00	17,349.56	17,349.56	TRUE
43		4,550.00	21,899.56	21,899.56	TRUE
44		1,350.00	23,249.56	23,249.56	TRUE
45	15,000.00		8,249.56	8,249.56	TRUE
46	5,000.00		3,249.56	3,249.56	TRUE
47		3,000.00	6,249.56	6,249.56	TRUE
48	2,334.00		3,915.56	3,915.56	TRUE
49	2,000.00		1,915.56	1,915.56	TRUE
50	500.00		1,415.56	1,415.56	TRUE
51		630.00	2,045.56	2,045.56	TRUE
52		630.00	2,675.56	2,675.56	TRUE
53		400.00	3,075.56	3,075.56	TRUE
54		1,000.00	4,075.56	4,075.56	TRUE
55		1,600.00	5,675.56	5,675.56	TRUE
56		10,000.00	15,675.56	15,675.56	TRUE
57	5,000.00		10,675.56	10,675.56	TRUE
58	5,000.00		5,675.56	5,675.56	TRUE
59	4,650.00		1,025.56	1,025.56	TRUE
60	1,000.00		25.56	25.56	FALSE
61		5,000.00	5,025.56	5,025.56	TRUE
62	1,000.00		4,025.56	4,025.56	TRUE
63		3,144.00	7,169.56	7,169.56	TRUE
64		500.00	7,669.56	7,669.56	TRUE
65		28,000.00	35,669.56	35,669.56	TRUE
66		5,000.00	40,669.56	40,669.56	TRUE
67	30,000.00		10,669.56	10,669.56	TRUE
68	118.00		10,551.56	10,551.56	TRUE
69	5,000.00		5,551.56	5,551.56	TRUE
70		20,000.00	25,551.56	25,551.56	TRUE
71		15,000.00	40,551.56	40,551.56	TRUE
72	21,033.00		19,518.56	19,518.56	TRUE
73	1,000.00		18,518.56	18,518.56	TRUE
74		3,335.00	21,853.56	21,853.56	TRUE
75	10,000.00		11,853.56	11,853.56	TRUE
76		1,650.00	13,503.56	13,503.56	TRUE
77	2,500.00		11,003.56	11,003.56	TRUE
78		38,198.00	49,201.56	49,201.56	TRUE
79	22,419.00		26,782.56	26,782.56	TRUE
80	10,300.00		16,482.56	16,482.56	TRUE
81		22,000.00	38,482.56	38,482.56	TRUE
82		3,546.00	42,028.56	42,028.56	TRUE
83		693.00	42,721.56	42,721.56	TRUE
84	7,136.00		35,585.56	35,585.56	TRUE
85	10,539.00		25,046.56	25,046.56	TRUE
86		14,000.00	39,046.56	39,046.56	TRUE
87	26,847.00		12,199.56	12,199.56	TRUE
88	11,550.00		649.56	649.56	FALSE
89		15,000.00	15,649.56	15,649.56	TRUE
90	10,000.00		5,649.56	5,649.56	TRUE
91	5,000.00		649.56	649.56	FALSE
92		10,225.00	10,874.56	10,874.56	TRUE
93	10,000.00		874.56	874.56	FALSE
94		1,750.00	2,624.56	2,624.56	TRUE
95		1,300.00	3,924.56	3,924.56	TRUE
96		1,500.00	5,424.56	5,424.56	TRUE
97		1,500.00	6,924.56	6,924.56	TRUE
98		1,300.00	8,224.56	8,224.56	TRUE
99		200.00	8,424.56	8,424.56	TRUE
100		30,000.00	38,424.56	38,424.56	TRUE
101	13,437.00		24,987.56	24,987.56	TRUE
102	20,000.00		4,987.56	4,987.56	TRUE
103	4,500.00		487.56	487.56	FALSE
104		2,000.00	2,487.56	2,487.56	TRUE
105		750.00	3,237.56	3,237.56	TRUE
106		13,250.00	16,487.56	16,487.56	TRUE
107	14,469.00		2,018.56	2,018.56	TRUE
108		4,000.00	6,018.56	6,018.56	TRUE
109		10,000.00	16,018.56	16,018.56	TRUE
110		1,960.00	17,978.56	17,978.56	TRUE
111	11,332.00		6,646.56	6,646.56	TRUE
112		2,905.00	9,551.56	9,551.56	TRUE
113		2,000.00	11,551.56	11,551.56	TRUE
114	8,741.00		2,810.56	2,810.56	TRUE
115		1,218.00	4,028.56	4,028.56	TRUE
116		2,500.00	6,528.56	6,528.56	TRUE
117		1,000.00	7,528.56	7,528.56	TRUE
118	118.00		7,410.56	7,410.56	TRUE
119		5,000.00	12,410.56	12,410.56	TRUE
120		10.00	12,420.56	12,420.56	TRUE
121		4,690.00	17,110.56	17,110.56	TRUE
122		4,185.00	21,295.56	21,295.56	TRUE
123	20,000.00		1,295.56	1,295.56	TRUE
124		11,000.00	12,295.56	12,295.56	TRUE
125		25,000.00	37,295.56	37,295.56	TRUE
126		865.00	38,160.56	38,160.56	TRUE
127	13,258.00		24,902.56	24,902.56	TRUE
128	24,273.00		629.56	629.56	FALSE
129		3,000.00	3,629.56	3,629.56	TRUE
130		9,000.00	12,629.56	12,629.56	TRUE
131		5,000.00	17,629.56	17,629.56	TRUE
132	15,000.00		2,629.56	2,629.56	TRUE
133	500.00		2,129.56	2,129.56	TRUE
134		2,462.00	4,591.56	4,591.56	TRUE
135		2,363.00	6,954.56	6,954.56	TRUE
136		3,800.00	10,754.56	10,754.56	TRUE
137		1,550.00	12,304.56	12,304.56	TRUE
138		540.00	12,844.56	12,844.56	TRUE
139		8,000.00	20,844.56	20,844.56	TRUE
140	20,000.00		844.56	844.56	FALSE
141		5,850.00	6,694.56	6,694.56	TRUE
142		3,330.00	10,024.56	10,024.56	TRUE
143		5,000.00	15,024.56	15,024.56	TRUE
144		20,619.00	35,643.56	35,643.56	TRUE
145	2,000.00		33,643.56	33,643.56	TRUE
146	3,000.00		30,643.56	30,643.56	TRUE
147	30,000.00		643.56	643.56	FALSE
148		3,000.00	3,643.56	3,643.56	TRUE
Match

Cell Formulas
Range	Formula
E1	E1	=IF(C437=D437,"Matched","Mismatch")
D2	D2	=C2
E2:E148	E2	=C2=D2
D3:D148	D3	=D2-A3+B3

 

[RAJESH1960]

I tried using this formula too =SUM(D59,-A60,+B60), but still I am not able to get True in all the cells in column E.

 

[AhoyNC]

If you look at your row 88 and extend out the decimal places you will see they are not equal.
Use the ROUND function to correct the issue.

Book1
	A	B	C	D	E	F	G
88	11550		649.5600000000000	649.5599999999980	FALSE		649.5600000000
Sheet1

Cell Formulas
Range	Formula
D88	D88	=D87-A88+B88
E88	E88	=C88=D88
G88	G88	=ROUND(D87-A88+B88,2)

 

[RAJESH1960]

If you look at your row 88 and extend out the decimal places you will see they are not equal.
Use the ROUND function to correct the issue.

Book1
	A	B	C	D	E	F	G
88	11550		649.5600000000000	649.5599999999980	FALSE		649.5600000000
Sheet1

Cell Formulas
Range	Formula
D88	D88	=D87-A88+B88
E88	E88	=C88=D88
G88	G88	=ROUND(D87-A88+B88,2)

Yup. Round did the trick. Thanks AhoyNC.?

 

[AhoyNC]

You're welcome. Thanks for the feedback.