I have a complex task and I am not sure if excel can do this or not.
This is really important so any help is very welcome.

I have given severel people a servay. Each question has seven possible
answers. They a strongly agree, agree, agree somewhat, neutral,
disagree somewhat, disagree, strongly disagree. I need to write a
function in excel such that when ever I enter one of these answers a
specific numerical value from 1-7 apears. For example, Strongly
agree=1, agree=2, agree somewhat =3 etc. . . . strongly disagree=7. So,
if a person answered agree somewhat then when I paste this answer into
the correct cell then 3 pops up as the value in that cell. Is this
possible? If so what is the function, formula, or array that I need to
use to do this?

I have figured out to do an if statement for two choices, but can a
statement be created that chooses between multiple choices?

any help anyone can give would be great
thanks,
tiger