Help with rounding changing number (total)

[m27mitchell]

Hello, I am trying to get C9 to balance out as $347,530.30. Can you help with this please? Please see image attached for details.

Original Contract Sum	$ 29,739,311.00	$ 29,739,311.00
Net Change by Change Order	$ 395,539.00	$ 395,539.00
Contract Sum to Date	$ 30,134,850.00	$ 30,134,850.00	<< Formula used =c2+c3
Total Completed and Stored to Date	$ 28,536,596.12	$ 28,902,417.48
Total Retainage	$ 1,426,829.81	$ 1,445,120.87	<< Formula used =c5*0.05
Total Earned Less Retainage	$ 27,109,766.31	$ 27,457,296.61	<< Formula used =c5-c6
Less Previous Certificates for Payment	$ 24,340,453.38	$ 27,109,766.31	<< Formula used =SUM(c8:c9)
Current Payment Due	$ 2,769,312.94	$ 347,530.29	<< Formula used =c7-c8
Balance to Finish, Including Retainage	$ 3,025,083.69	$ 2,677,553.39	<< Formula used =c4-c7
How do I get it to balance out so that the total is $347,590.30? I know it's automatically rounding the numbers from c7 and c8, but it's not carrying over to b9

<colgroup><col width="304" style="width: 228pt; mso-width-source: userset; mso-width-alt: 11117;"> <col width="154" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5632;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="195" style="width: 146pt; mso-width-source: userset; mso-width-alt: 7131;"> <tbody> </tbody>

 

[mrshl9898]

When pasting the figures in and applying your formulas I get 347530.30.

I'd suspect there are additional decimal places throwing this that little bit off. Try rounding your formulas, eg. =ROUND(C2+C3,2).


Also not sure what the SUM(C8:C9) is doing. It creates a circular reference and is identical to B7.

 

[m27mitchell]

When pasting the figures in and applying your formulas I get 347530.30.

I'd suspect there are additional decimal places throwing this that little bit off. Try rounding your formulas, eg. =ROUND(C2+C3,2).


Also not sure what the SUM(C8:C9) is doing. It creates a circular reference and is identical to B7.

Thank you!