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.
<tbody>
</tbody>
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!
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.
Name1 | Michael |
Name2 | Jeff |
Probabilities for Michael & Jeff | |
Result | Probability |
1 | 10% |
2 | 5% |
3 | 50% |
4 | 35% |
<tbody>
</tbody>
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!