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.


[TABLE="width: 570"]
<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>[TR]
[TD="width: 304, bgcolor: transparent"][/TD]
[TD="width: 154, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 195, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Original Contract Sum[/TD]
[TD="bgcolor: transparent"] $ 29,739,311.00 [/TD]
[TD="bgcolor: transparent"] $ 29,739,311.00 [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Net Change by Change Order[/TD]
[TD="bgcolor: transparent"] $ 395,539.00 [/TD]
[TD="bgcolor: transparent"] $ 395,539.00 [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Contract Sum to Date[/TD]
[TD="bgcolor: transparent"] $ 30,134,850.00 [/TD]
[TD="bgcolor: transparent"] $ 30,134,850.00 [/TD]
[TD="bgcolor: transparent"]<< Formula used =c2+c3[/TD]
[/TR]
[TR]
[TD="bgcolor: #CCFFCC"]Total Completed and Stored to Date[/TD]
[TD="bgcolor: #CCFFCC"] $ 28,536,596.12 [/TD]
[TD="bgcolor: #CCFFCC"] $ 28,902,417.48 [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: #FFFF99"]Total Retainage[/TD]
[TD="bgcolor: #FFFF99"] $ 1,426,829.81 [/TD]
[TD="bgcolor: #FFFF99"] $ 1,445,120.87 [/TD]
[TD="bgcolor: transparent"]<< Formula used =c5*0.05[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Total Earned Less Retainage[/TD]
[TD="bgcolor: transparent"] $ 27,109,766.31 [/TD]
[TD="bgcolor: transparent"] $ 27,457,296.61 [/TD]
[TD="bgcolor: transparent"]<< Formula used =c5-c6[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Less Previous Certificates for Payment[/TD]
[TD="bgcolor: transparent"] $ 24,340,453.38 [/TD]
[TD="bgcolor: transparent"] $ 27,109,766.31 [/TD]
[TD="bgcolor: transparent"]<< Formula used =SUM(c8:c9)[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Current Payment Due[/TD]
[TD="bgcolor: transparent"] $ 2,769,312.94 [/TD]
[TD="bgcolor: transparent"] $ 347,530.29 [/TD]
[TD="bgcolor: transparent"]<< Formula used =c7-c8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Balance to Finish, Including Retainage[/TD]
[TD="bgcolor: transparent"] $ 3,025,083.69 [/TD]
[TD="bgcolor: transparent"] $ 2,677,553.39 [/TD]
[TD="bgcolor: transparent"]<< Formula used =c4-c7[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 760, bgcolor: transparent, colspan: 4"]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[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

 

[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!