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

New Contributor

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?Yes2No0 
Is the chance of it impacting service >50%?Yes1No0 
Will it (or is it) impacting more than one office?Yes1No0 
Will it (or is it) impacting more than one service?Yes1No0 
Will it (or is it) impacting a client?Yes1No0 
      
      
2 Replies

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

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