Hi all sorry if this has been answered before but I could not find a thread.

1 I am creating a Q and A form and the answers will then generate a score. i.e Daily = 5, most days 3, most weeks = 2, most months = 1 and rare/ 1st call = 0 (this is the longest) What would be the formula please have tried a few but can not get more than one word to equal a number rather than the 6 I need?

2 there are 6 questions to be scored and then they need to be added up to give a grand total.

3 I have seen another form that you can double click on the cell and you then get a multiple chioce you can chose from i.e daily, most days etc. Is this a formula or a function I am not aware about.

Thanks in anticipation
Pete