View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wizard475 Wizard475 is offline
external usenet poster
 
Posts: 4
Default Limited value based on percentage of total

I have 5 #s. each represents a percentage of the total. how can i limit a
number's percentage @ 30% and have what is left move to the remaining
numbers, all the while no one number can be greatter than 30% of the total.

18 0.005552647
228 0.069816829
760 0.232627383
1,177 0.360402951
1,083 0.331600189

3,266