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