Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Allocating percentages
I have percentages in B2:B30 which add up to 100%, and an amount to allocate
in A2 (for example, 8). However, the results must be integers, and must add up to A2. The simple formula is =round($A$2*B2,0) copied down, but the rounding doesn't always produce the right total. How do I ensure that the total always equals A2? Thanks, Fred |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allocating remainders | Excel Worksheet Functions | |||
Allocating the numbers from the total | Excel Worksheet Functions | |||
Allocating usage across aging buckets | Excel Worksheet Functions | |||
Allocating a value from a cell | Excel Worksheet Functions | |||
Allocating a Value | Excel Worksheet Functions |