Random Number Generating

Hello everyone, I need some help here.

I want to take a range of cells and generate a random percentage for each cell between 1% and 100% with the total combined value not to exceed 100%

for example.

cell a1 - 02% cell b1 - 03%
cell a2 - 04% cell b2 - 12%
cell a3 - 32% cell b3 - 22%
cell a4 - 18% cell b4 - 17%
cell a5 - 25% cell b5 - 37%
cell a6 - 13% cell b6 - 08%
cell a7 - 06% cell b7 - 01%

total = 100% total = 100%

Check the attachment....u can hide the columns which have random numbers....

hope this helps u

Regards,
guru

If you want even percents (i.e., exactly two decimals), then

Please Login or Register  to view this content.

B2 and down: =RAND()

C2 and down: =IF( B2 = 0, 0, ROUND(B2 * (1 - SUM(C$1:C1) ) / ($B$9 - SUM(B$1:B1)), 2) )