Hard to do? randomly
 

The number i put in cell A31 must be ditributed randomly from cell A1 to
A30 so the summary of A1 to A30 must be like A31. Is this possible?

Farmer

Hard to do? randomly
 

Very easy:

In B1 thru B30 enter:
=RAND()

In B31 enter:
=SUM(B1:B30)

In A31 put your value

In A1 enter:
=$A$31*B1/$B$31 and copy down thru A30

A1 thru A30 will consist of random values which sum to the value in A 31.

--
Gary''s Student - gsnu2007g


"farmer" wrote:

The number i put in cell A31 must be ditributed randomly from cell A1 to
A30 so the summary of A1 to A30 must be like A31. Is this possible?

Farmer

Hard to do? randomly
 

Thanks alot , you people are great.
Farmer
"Gary''s Student" wrote in message
...
Very easy:

In B1 thru B30 enter:
=RAND()

In B31 enter:
=SUM(B1:B30)

In A31 put your value

In A1 enter:
=$A$31*B1/$B$31 and copy down thru A30

A1 thru A30 will consist of random values which sum to the value in A 31.

--
Gary''s Student - gsnu2007g


"farmer" wrote:

The number i put in cell A31 must be ditributed randomly from cell A1 to
A30 so the summary of A1 to A30 must be like A31. Is this possible?

Farmer

Hard to do? randomly
 

Hello,

That's one possible solution. The distribution will almost look like
the green curve shown at:
http://www.sulprobil.com/html/randsum1.html
The maximum (meaning the most likely values) will be at A31/30.

If you like to test other possible distributions as well:

Select A1:A30 and array-enter
=A31*randsum1(1)
or
=A31*randsum1(3)

Regards,
Bernd