I am creating a fitness survey.
A portion of it is nutritional. I think this should be pretty easy, but I have several questions, all of which have the following answer choices:
- Never
- Rarely
- Sometimes
- Often
- Always
I want to be able to store the answers to each of the questions as a number. For example, Never would be a 0, Rarely a 1, and so on. I want it so that it will store just the number in a column so that I can add them up and give them a score later on using a formula.
I can do the scoring part, but how to I make it so that I can associate those choices with a number. I feel like there should be a simple If/then for this, but I am not exactly an expert programmer, so any help would be very useful.
Thanks!