PDA

View Full Version : [SOLVED] Random numbers with specific outcome



Juriemagic
01-12-2015, 05:31 AM
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
01-14-2015, 03:30 AM
2 questions:
is the sum always 200?
Do you have a limited number of constants? or it can change each time?

Juriemagic
01-14-2015, 03:37 AM
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
01-14-2015, 03:50 AM
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