Random Values

[aliikhlaq2006]

I have null value in Cell A1:A9 and some random number in Cell A11. I want to generate random numbers in Cell A1:A9 that its sum in A10 is equals to A11. I try with solver but unfortunately solver divides the A11 value by 9 and put the values in A1:A9.

 

[jasonb75]

You will need to use something like this.

Manexcel.xlsx
	A	B
1	4.175994	0.192875
2	2.036094	0.09404
3	21.38684	0.987786
4	20.35891	0.94031
5	8.739837	0.403664
6	19.29063	0.890969
7	10.82428	0.499937
8	1.728333	0.079826
9	8.459079	0.390696
10	97	21.65128
11	97
Sheet3

Cell Formulas
Range	Formula
B1:B9	B1	=RAND()
B10	B10	=A11/SUM(B1:B9)
A1:A9	A1	=B1*$B$10
A10	A10	=SUM(A1:A9)
A11	A11	=RANDBETWEEN(1,100)

 

[aliikhlaq2006]

You will need to use something like this.

Manexcel.xlsx
	A	B
1	4.175994	0.192875
2	2.036094	0.09404
3	21.38684	0.987786
4	20.35891	0.94031
5	8.739837	0.403664
6	19.29063	0.890969
7	10.82428	0.499937
8	1.728333	0.079826
9	8.459079	0.390696
10	97	21.65128
11	97
Sheet3

Cell Formulas
Range	Formula
B1:B9	B1	=RAND()
B10	B10	=A11/SUM(B1:B9)
A1:A9	A1	=B1*$B$10
A10	A10	=SUM(A1:A9)
A11	A11	=RANDBETWEEN(1,100)

Thank you so much it worked for me Great!