Creating size breakdowns with percentages

Thanks for the response. I want Excel break it down into S,M,L,XL based on certain percentages. For example when i enter 80 units. I want excel to spit in separate columns the size breaks ex) S 16, M 24, and so on...