Round/Force Formulas to Add up to Total

[dnalsk]

I have a total cost for a product/service and have been using formulas to allocate based on each companys usage as shown below. My problem is, when shown to 2 decimal places, the total for each company adds up to a 0.01 less than the total. Is there anyway to force these 3 amounts to add up to the total?

Company A Company B Company C Total
Cost 2710.14512 3159.74909 964.105780 6834

Thanks in advance

 

[PritishS]

Hi,

May be this formula--

In Col-D2

=ROUND(SUM(A2:C2),0)

You can change 0 as per your requirement for numbers after decimal.

Thanks & Regards
PritishS

 

[dnalsk]

Hi,

May be this formula--

In Col-D2

=ROUND(SUM(A2:C2),0)

You can change 0 as per your requirement for numbers after decimal.

Thanks & Regards
PritishS

That doesn't quite do what I want. I dont want the total to be rounded, i need the costs per company to actually add up to the total. I believe the decimal places cause the problem here.