something more efficient that =IF, and sytax questions

[mcrae]

I have a column with numerical values, representing which choice
person chose on a questionaire. I want to create a new column whic
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 wa
wondering if there was a faster way to do it?

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

thanks

 

[Guest]

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.

 

[Guest]

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