Value to answers on Excel

New Contributor

Hello - and thanks to whoever helps!


I've collected answers in the form of a questionnaire on Google forms, and now I have them on an Excel document. I'm trying to attribute a value to each answer (Yes = 4, Sometimes = 2, No = 0) and have them added at the end of each individual submission of the questionnaire - but I have not succeded.

Can someone help?


2 Replies
best response confirmed by RSS96 (New Contributor)


Let's say the answers are in B2:B20.



Helped so much!! Thanks