Hi All,
Hope someone can help with this...
I have 8 statements that can all have an answer between 0 and 4, if the statements total a value between two numbers this produces a pre-defined outcome, however what I have been asked to do is if all statements have an answer of 3 or 4 and only one of the answers is 2 then a different outcome is produced with the result being "3G".
I have re-created the sort of table I am looking at below with the results in columns B and E. If the outcome of all statements was as below this would produce the "3G" outcome but the spread of 3's and 4's and one 2 could be totally random.
<tbody>
</tbody>
What is the best formula to use for this?
Thank you for your help.
Rob
Hope someone can help with this...
I have 8 statements that can all have an answer between 0 and 4, if the statements total a value between two numbers this produces a pre-defined outcome, however what I have been asked to do is if all statements have an answer of 3 or 4 and only one of the answers is 2 then a different outcome is produced with the result being "3G".
I have re-created the sort of table I am looking at below with the results in columns B and E. If the outcome of all statements was as below this would produce the "3G" outcome but the spread of 3's and 4's and one 2 could be totally random.
A | B | C | D | E |
Statement 1 | 3 | Statement 5 | 4 | |
Statement 2 | 4 | Statement 6 | 4 | |
Statement 3 | 2 | Statement 7 | 3 | |
Statement 4 | 3 | Statement 8 | 4 |
<tbody>
</tbody>
What is the best formula to use for this?
Thank you for your help.
Rob