Thread: 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

      --A-- --B--- --C---
  1                      
  2          0.34   12.0%
  3          0.12    4.0%
  4          0.60   23.0%
  5          0.16    6.0%
  6          0.49   18.0%
  7          0.73   27.0%
  8          0.26   10.0%
  9   Total  2.70  100.0%

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) )