Forum Discussion
How to Return a Value depending in whether a response is Yes or No
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...
=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
