Jan 07 2022 10:46 AM
Hi ,
I am trying to link a score to a "yes"/"no" response. If you look at the below I have a selection of question that some one can answer yes or no to. Depending on their response I need each line item to come back with a score. I have provided an idea in the second table. What is the best way to do this. I assume some sort of logical function but that seems to need only numbers.
Is it currently impacting service? | Yes | ||||
Is the chance of it impacting service >50%? | Yes | ||||
Will it (or is it) impacting more than one office? | Yes | ||||
Will it (or is it) impacting more than one service? | Yes | ||||
Will it (or is it) impacting a client? | Yes | ||||
Is it currently impacting service? | Yes | 2 | No | 0 | |
Is the chance of it impacting service >50%? | Yes | 1 | No | 0 | |
Will it (or is it) impacting more than one office? | Yes | 1 | No | 0 | |
Will it (or is it) impacting more than one service? | Yes | 1 | No | 0 | |
Will it (or is it) impacting a client? | Yes | 1 | No | 0 | |
Jan 07 2022 11:04 AM
=IF(B1=B9,C9,E9)
Maybe with an IF function as shown in the attached file. Enter IF function in cell C1 and copy down to cell C5.
Jan 07 2022 11:29 AM