F
Fred Smith
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
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