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

[LakinE]

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

[#2]

@LakinE 

=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.

[#3]

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