Forum Discussion
LakinE
Jan 07, 2022Copper Contributor
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...
OliverScheurich
Jan 07, 2022Gold Contributor
=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.
LakinE
Jan 07, 2022Copper Contributor
Thanks I was trying to way over complicate this... long week lol