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:

1	5%
2	10%
3	0%
4	20%
5	30%
6	10%
7	10%
8	10%
9	5%

<tbody>
</tbody>

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