Round/Force Formulas to Add up to Total

dnalsk

New Member
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

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

PritishS

Board Regular
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

New Member
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.

Replies
11
Views
2K
Replies
1
Views
351
Replies
4
Views
1K
Replies
5
Views
570
Replies
2
Views
111

1,191,177
Messages
5,985,140
Members
439,942
Latest member
bkexcel11230

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back