Weighted Probabilities with random numbers

[senx7810]

Hi guys, this has been killing me but does anyone know how to incorporate weighted probabilities with random numbers? For example:

I need to have a random number between 1-9 and have these probabilities:
[TABLE="width: 240"]
<tbody>[TR]
[TD]1[/TD]
[TD]5%[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10%[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]20%[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]30%[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]10%[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]10%[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]10%[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]5%[/TD]
[/TR]
</tbody>[/TABLE]

Any help would be much appreciated!

I just need a formula please and thank you.

 

[shg]

Welcome to the board.

=match(rand(), {0;5;15;15;35;65;75;85;95}%)

 

[senx7810]

Thank you so much!

 

[shg]

You're welcome.

 

[kcmuppet]

Welcome to the board.

=match(rand(), {0;5;15;15;35;65;75;85;95}%)

Hi shg - how does this work?

Not being a mathematician, I can't see immediately the relationship between the percentages senx7810 wanted and the number you put in the curly brackets.

Thanks