Rounding Percentages

[jvilline]

Hi, your formula works great! Can you do the same thing in reverse? How would you go from allocation to percentage? Please publish the formula.

Thanks,
John

http://www.excelforum.com/excel-work...rcentages.html

[mikerickson]

...The problem I am having, is the % of the market is not a whole number. When it calculates the total number of products to be sent to each site, it then gives a decimal place answer, and you CAN'T send out 3.45 of a WHOLE item to a site. ....

You can't send out 3.45 items, but the non-integer figure is a %, not an item count.

Are you sure that's a problem?

If I ship 1 can each to 3 folks, each of them gets 33.33% of the total. One can send a non-integer % of product.

[Paul]

Hi John, and welcome to the forum. Please take a moment to read the forum rules, and in the future start your own threads rather than "hijacking" someone else's. If someone else's thread seems particularly relevant, post a link to it in the thread, like I've done for you below.

Thanks!

http://www.excelforum.com/excel-work...rcentages.html

[darkyam]

Allocation to percentage is easy. If I have twenty items sent to store A out of 100 total items, I simply take =20/100-->20%. As Mike said, you wouldn't start with a fractional number for the items. You also wouldn't have the same problem the OP of the original post had because, as long as you did this for all allocations, your percentages would naturally add up perfectly to 100%.