Hi,
I have to find a solution which I'm not entirely sure if it can be done by excel.
I have a table with 11 conditions, and depending on whether the conditions are met, there will be 4 outcomes.
<tbody>
</tbody>
Here's the restrictions to be imposed:
1. If either Condition 1 or Condition 2 is true, I want Result A. Whether any other conditions are true is irrelevant.
2. If any of Condition 3 to Condition 9 is true, I want Result B. This is regardless whether Condition 10 or Condition 11 is true
3. If only Condition 10 or Condition 11 is true, I want Result C and Result D respectively.
I have to find a solution which I'm not entirely sure if it can be done by excel.
I have a table with 11 conditions, and depending on whether the conditions are met, there will be 4 outcomes.
A | B | C | |
1 | Condition 1 | True | Result A |
2 | Condition 2 | False | Result A |
3 | Condition 3 | False | Result B |
4 | Condition 4 | True | Result B |
5 | Condition 5 | False | Result B |
6 | Condition 6 | False | Result B |
7 | Condition 7 | False | Result B |
8 | Condition 8 | True | Result B |
9 | Condition 9 | True | Result B |
10 | Condition 10 | True | Result C |
11 | Condition 11 | False | Result D |
<tbody>
</tbody>
Here's the restrictions to be imposed:
1. If either Condition 1 or Condition 2 is true, I want Result A. Whether any other conditions are true is irrelevant.
2. If any of Condition 3 to Condition 9 is true, I want Result B. This is regardless whether Condition 10 or Condition 11 is true
3. If only Condition 10 or Condition 11 is true, I want Result C and Result D respectively.