Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add column for percentage o total | Excel Discussion (Misc queries) | |||
Percentage total may not exceed 100 | Excel Discussion (Misc queries) | |||
Total Revenue Percentage | Excel Discussion (Misc queries) | |||
Percentage Discount Total | Excel Discussion (Misc queries) | |||
a number as a percentage out of a total | Excel Worksheet Functions |