Wizard475 wrote:
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


With your numbers in A1:A5, sorted descending

B1=IF(A1SUM($A$1:$A$5)*0.3,INT(SUM($A$1:$A$5)*0.3 ),A1)
B2=IF((A2+SUM($A$1:A1)-SUM($B$1:B1))SUM($A$1:$A$5)*0.3,INT(SUM($A$1:$A$5 )*0.3),(A2+SUM($A$1:A1)-SUM($B$1:B1)))

Fill B2 down to B5

If that's not the result you desire, then more information is needed.