I was using this forumula, which I found in another thread here...

=IF(A2="","",MATCH(A2,{"I strongly disagree","I disagree","Neutral", "I
agree","I strongly
agree"},FALSE))


Is there any way to set your own values for what these mean? I don't want
strongly disagree to equal 1, but zero. I tried changing false to -1, but it
didn't work. What can I do to set up specific values for each option?

Thanks

One way, using INDEX / MATCH:
=IF(A2="","",INDEX({0;1;2;3;4},MATCH(A2,{"I strongly disagree";"I
disagree";"Neutral";"I agree";"I strongly agree"},0)))

Above will return the values: {0;1;2;3;4}
corresponding to:
{"I strongly disagree";"I disagree";"Neutral";"I agree";"I strongly agree"}
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Anonymous" wrote in message
...
I was using this forumula, which I found in another thread here...

=IF(A2="","",MATCH(A2,{"I strongly disagree","I disagree","Neutral", "I
agree","I strongly
agree"},FALSE))


Is there any way to set your own values for what these mean? I don't want
strongly disagree to equal 1, but zero. I tried changing false to -1, but
it
didn't work. What can I do to set up specific values for each option?

Thanks

Thank You!!!

"Max" wrote:

One way, using INDEX / MATCH:
=IF(A2="","",INDEX({0;1;2;3;4},MATCH(A2,{"I strongly disagree";"I
disagree";"Neutral";"I agree";"I strongly agree"},0)))

Above will return the values: {0;1;2;3;4}
corresponding to:
{"I strongly disagree";"I disagree";"Neutral";"I agree";"I strongly agree"}
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Anonymous" wrote in message
...
I was using this forumula, which I found in another thread here...

=IF(A2="","",MATCH(A2,{"I strongly disagree","I disagree","Neutral", "I
agree","I strongly
agree"},FALSE))


Is there any way to set your own values for what these mean? I don't want
strongly disagree to equal 1, but zero. I tried changing false to -1, but
it
didn't work. What can I do to set up specific values for each option?

Thanks

You're welcome !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Anonymous" wrote in message
...
Thank You!!!