software

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

=IF(A2=quot;quot;,quot;quot;,MATCH(A2,{quot;I strongly disagreequot;,quot;I disagreequot;,quot;Neutralquot;, quot;I
agreequot;,quot;I strongly
agreequot;},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=quot;quot;,quot;quot;,INDEX({0;1;2;3;4},MATCH(A2,{quot;I strongly disagreequot;;quot;I
disagreequot;;quot;Neutralquot;;quot;I agreequot;;quot;I strongly agreequot;},0)))

Above will return the values: {0;1;2;3;4}
corresponding to:
{quot;I strongly disagreequot;;quot;I disagreequot;;quot;Neutralquot;;quot;I agreequot;;quot;I strongly agreequot;}
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Anonymousquot; gt; wrote in message
...
gt; I was using this forumula, which I found in another thread here...
gt;
gt; =IF(A2=quot;quot;,quot;quot;,MATCH(A2,{quot;I strongly disagreequot;,quot;I disagreequot;,quot;Neutralquot;, quot;I
gt; agreequot;,quot;I strongly
gt; agreequot;},FALSE))
gt;
gt;
gt; Is there any way to set your own values for what these mean? I don't want
gt; strongly disagree to equal 1, but zero. I tried changing false to -1, but
it
gt; didn't work. What can I do to set up specific values for each option?
gt;
gt; Thanks
Thank You!!!

quot;Maxquot; wrote:

gt; One way, using INDEX / MATCH:
gt; =IF(A2=quot;quot;,quot;quot;,INDEX({0;1;2;3;4},MATCH(A2,{quot;I strongly disagreequot;;quot;I
gt; disagreequot;;quot;Neutralquot;;quot;I agreequot;;quot;I strongly agreequot;},0)))
gt;
gt; Above will return the values: {0;1;2;3;4}
gt; corresponding to:
gt; {quot;I strongly disagreequot;;quot;I disagreequot;;quot;Neutralquot;;quot;I agreequot;;quot;I strongly agreequot;}
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;Anonymousquot; gt; wrote in message
gt; ...
gt; gt; I was using this forumula, which I found in another thread here...
gt; gt;
gt; gt; =IF(A2=quot;quot;,quot;quot;,MATCH(A2,{quot;I strongly disagreequot;,quot;I disagreequot;,quot;Neutralquot;, quot;I
gt; gt; agreequot;,quot;I strongly
gt; gt; agreequot;},FALSE))
gt; gt;
gt; gt;
gt; gt; Is there any way to set your own values for what these mean? I don't want
gt; gt; strongly disagree to equal 1, but zero. I tried changing false to -1, but
gt; it
gt; gt; didn't work. What can I do to set up specific values for each option?
gt; gt;
gt; gt; Thanks
gt;
gt;
gt;

You're welcome !
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Anonymousquot; gt; wrote in message
...
gt; Thank You!!!