I have a column with numerical values, representing which choice a
person chose on a questionaire. I want to create a new column which
will look at the old column and do =IF(C2=1,"Yes", (IF(C2=2, "No",
"Perhaps")))

the problem is for some questions i have 12 different answers, so i was
wondering if there was a faster way to do it?

another problem, some of my answers are '0 - 1' (question is how many
hours do you watch tv per day). I don't know how to get excel to
actually display 0 - 1, it will either display some large number, or a
date.

thanks!


--
mcrae
------------------------------------------------------------------------
mcrae's Profile: http://www.excelforum.com/member.php...o&userid=30252
View this thread: http://www.excelforum.com/showthread...hreadid=528815

You could create a lookup table, with a table for group of answers. So if
there are three choice for your first question you could put a lookup table
in Sheet 2 that looks like this:

A B
1 Yes
2 No
3 Perhaps

Name the range Question1 and the vlookup would look something like this:

=VLOOKUP(A1, Question1, 2)

Where A1 is the response in sheet 1
Question1 is your lookup table for question 1
and 2 is the column to get the return value from.
--
Kevin Backmann


"mcrae" wrote:


I have a column with numerical values, representing which choice a
person chose on a questionaire. I want to create a new column which
will look at the old column and do =IF(C2=1,"Yes", (IF(C2=2, "No",
"Perhaps")))

the problem is for some questions i have 12 different answers, so i was
wondering if there was a faster way to do it?

another problem, some of my answers are '0 - 1' (question is how many
hours do you watch tv per day). I don't know how to get excel to
actually display 0 - 1, it will either display some large number, or a
date.

thanks!


--
mcrae
------------------------------------------------------------------------
mcrae's Profile: http://www.excelforum.com/member.php...o&userid=30252
View this thread: http://www.excelforum.com/showthread...hreadid=528815

I just read your second question, and formatting the cell as TEXT format
before should correct this problem.
--
Kevin Backmann


"mcrae" wrote:


I have a column with numerical values, representing which choice a
person chose on a questionaire. I want to create a new column which
will look at the old column and do =IF(C2=1,"Yes", (IF(C2=2, "No",
"Perhaps")))

the problem is for some questions i have 12 different answers, so i was
wondering if there was a faster way to do it?

another problem, some of my answers are '0 - 1' (question is how many
hours do you watch tv per day). I don't know how to get excel to
actually display 0 - 1, it will either display some large number, or a
date.

thanks!


--
mcrae
------------------------------------------------------------------------
mcrae's Profile: http://www.excelforum.com/member.php...o&userid=30252
View this thread: http://www.excelforum.com/showthread...hreadid=528815