IF Formula Multiple Choice

[thisisapita]

Hi I tried searching but could not find a thread that covered the same information, but I may be searching the wrong terms so I said I'd try asking, firstly I'm using excel 2003 on windows 7.

I am looking to write a formula for the answers to a multiple choice questionnaire on Google docs, so I have an excel spreadsheet with the numbers participants selected as their answers. From what I've read so far I tried to use the formula, IF(B2, 1, 2) however the issue is I need the value_if_false section to be all other variables, I've tried entering them as 0,2,3,4,5,6,7,8 and as 0 2 3 4 5 6 7 8, both of which excel rejected. I was wondering if I there was a way to use the IF formula for this function or if perhaps there was a better formula to use?

Thanks in advance for any help you can offer!

 

[tigeravatar]

thisisapita,

The most straightforward answer is to nest If formulas:
=IF(B2=0,"Value if 0",IF(B2=2,"Value if 2",IF(B2=3,"Value if 3"..)))

This probably isn't the most efficient solution though. Hard to provide a better answer without more context