Random numbers with specific outcome

[Juriemagic]

			200
0.05	0.1	0.5	1	2	5	10
0.5	1	5.5	11	22	50	110		200

Hi guys, I hope I did the insert right. For some reason on my pc I cannot upload files, will try and sort out with IT..anyways please help with this scenario?

Would it be possible to generate random numbers which are restricted so that when they are added, sums to 200 in this illustration, BUT also, they have to be multiples of their constants (Bold numbers)?..Any help will be greatly appreciated..please..

[ValerieT]

2 questions:
is the sum always 200?
Do you have a limited number of constants? or it can change each time?

[Juriemagic]

Hi ValerieT,

What a coincidence!..I have just now received a great solution on the excel Help Forum, which was a bit of a different scenario, but somehow incorporated the same problem as described here, just tested now and all works great!. I tried to post the link but am still un-able to do so. Thank you for coming back to me though..

[ValerieT]

Can you paste the link at least as text? I'm interesting by this topic, I'll feel mathematic smarter if I understand the logic of the solution LOL