Round formula and percentage multiplication error

Hi

I have percentages in the cells A1 to F1.
A1 B1 C1 D1 E1 F1
10.0% 2.0% 1.0% 1.0% 85.0% 1.0%

i have to multiply this percentages with whole number 60 to get the breakup, since i want whole number as result in each cell.
If i do normal multiplication i get decimals with overall sum as 60

A1 B1 C1 D1 E1 F1 sum
6.00 1.20 0.60 0.60 51.00 0.60 60.00

And if i use round formula i get whole number , but the sum is 61

A1 B1 C1 D1 E1 F1 sum
6 1 1 1 51 1 61.00

This is just the example , i have to use this at many places, and end of it, i lose or gain +-30 units with round formula.

Any workaround for this issue.

Any assistance will be highly appreciated guys..
Thanks

Hi Glenn
But i really cant adjust it to zeros and send this number to dealer.
Its regarding vehicle details, so finally when they copy this number in system, its still shows decimal point even when i just display it as zero.
Like example 0.5 will be displayed as 1, but when they copy it as it will still show as 0.5 vehicle unit.

Is there any formula which retains my total and yet give me percentage breakup as whole number?

Thanks glenn.

Maybe change the formula in say, F1 to be

Formula:

=60 - SUM(A1:E1)

hi sktneer

but again that is just displaying as whole number, when you upload that in system, it will still be decimal point..

There seems to be a lot of confusion here.

anzafsa, can you please confirm or deny my understanding.

"There are X amount of units split between 6 different %s that add up to 100%. You want to know the split in units, in whole numbers, based on those %s such that it adds up to X exactly."

If so, please refer to post above.