How to Return a Value depending in whether a response is Yes or No

Question

Hi ,&nbsp;I am trying to link a score to a "yes"/"no" response.&nbsp; If you look at the below I have a selection of question that some one can answer yes or no to.&nbsp; Depending on their response I need each line item to come back with a score.&nbsp; I have provided an idea in the second table.&nbsp; What is the best way to do this.&nbsp; I assume some sort of logical function but that seems to need only numbers.&nbsp;&nbsp;&nbsp;&nbsp;Is it currently impacting service?Yes&nbsp;&nbsp;&nbsp;&nbsp;Is the chance of it impacting service &gt;50%?Yes&nbsp;&nbsp;&nbsp;&nbsp;Will it (or is it) impacting more than one office?Yes&nbsp;&nbsp;&nbsp;&nbsp;Will it (or is it) impacting more than one service?Yes&nbsp;&nbsp;&nbsp;&nbsp;Will it (or is it) impacting a client?Yes&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Is it currently impacting service?Yes2No0&nbsp;Is the chance of it impacting service &gt;50%?Yes1No0&nbsp;Will it (or is it) impacting more than one office?Yes1No0&nbsp;Will it (or is it) impacting more than one service?Yes1No0&nbsp;Will it (or is it) impacting a client?Yes1No0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

oliverscheurich · Answer

LakinE&nbsp;=IF(B1=B9,C9,E9)&nbsp;Maybe with an IF function as shown in the attached file. Enter IF function in cell C1 and copy down to cell C5.

lakine · Answer

Thanks I was trying to way over complicate this... long week lol

Forum Discussion

How to Return a Value depending in whether a response is Yes or No

2 Replies

Resources

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