# IF Formula Multiple Choice

#### thisisapita

##### New Member
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?

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
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

Replies
9
Views
335
Replies
1
Views
133
Replies
1
Views
130
Replies
2
Views
199
Replies
1
Views
151

1,207,169
Messages
6,076,910
Members
446,239
Latest member
Home Nest

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back