Complex IF statement w/ Rand

[Dkmike32]

Hello,

I am trying to do this:
1. I have 2 cells with a list of names (2 names each).
2. I need an if-statement that when the names are chosen in any combination, the if statement will calculate a random number from another list (let's say numbers are 1-5) and each number will have a weighted average to it's random calculation.

Ex.
[TABLE="width: 139"]
<tbody>[TR]
[TD]Name1[/TD]
[TD]Michael[/TD]
[/TR]
[TR]
[TD]Name2[/TD]
[TD]Jeff[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Probabilities for Michael & Jeff[/TD]
[/TR]
[TR]
[TD]Result[/TD]
[TD]Probability[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]10%[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]5%[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]50%[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]35%[/TD]
[/TR]
</tbody>[/TABLE]

The If statement will spit out one of the results based on the probability.

I hope this makes sense, if not let me know and I will try to clarify more!

 

[Carpaccio]

Hi Dkmike32

I wander if a previous thread on something similar will suit you:
https://www.mrexcel.com/forum/excel-questions/372071-random-numbers-assigned-probabilities.html

HTH
Alan