PS if you don't want the formula to be case sensitive then:

=IF(UPPER(A1)="STRONGLY AGREE",1,IF(UPPER(A1)="AGREE",2,IF(UPPER(A1)="AGRE E
SOMEWHAT",3,IF(UPPER(A1)="NEUTRAL",4,IF(UPPER(A1)= "DISAGREE
SOMEWHAT",5,IF(UPPER(A1)="DISAGREE",6,IF(UPPER(A1) ="STRONGLY
DISAGREE",7,"")))))))

Regards
Rowan

"Rowan" wrote:

7 options you can do with nested if statements as follows:

=IF(A1="strongly agree",1,IF(A1="Agree",2,IF(A1="agree
somewhat",3,IF(A1="neutral",4,IF(A1="disagree
somewhat",5,IF(A1="disagree",6,IF(A1="strongly disagree",7,"")))))))

if you want to have more options you should set up a refrence table and use
the Vlookup function, see:

http://www.contextures.com/xlFunctions02.html

hope this helps
Rowan

"tiger" wrote:

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