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!
