#### jroo888

##### New Member
So the row of cells will read Choice1A or Choice1B or Choice1C or Choice1D
(depending on what their answer is)
After they do 50 questions their answers will look like this (one answer per cell)
Choice1A (then next cell) Choice2C (then next cell) Choice3D
What I am trying to do is put a formula in a different Cell that will look at each cell and tell give me a 1 if the answer is correct or a 0 if the answer is incorrect...
I put this formula in and it reads correctly for some cells but for others it says 0 when the answer is clearly correct:
This is the formula I put in example: =IF(L7="Choice2D",1,0)
Well in Cell L7 the answer IS Choice2D but the answer cell is stating 0 when it should state 1
Plz. Help... Thx.

### Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Are you sure you have no leading spaces in the cell?

Try
=IF(TRIM(L7)="Choice2D",1,0)

Last edited:
I thought we had it figured out... but no I checked and I have no spaces at all in the formula nor before the =
Any other thoughts??

I didn't mean where the formula is I meant in L7. See if the formula I posted returns a 1

THANK YOU VERY VERY VERY MUCH!!!!!!!!!!!!
That Worked!!!!!!!!!!!!!!

Replies
2
Views
610
Replies
3
Views
130
Replies
2
Views
222
Replies
10
Views
205
Replies
12
Views
577

1,203,094
Messages
6,053,506
Members
444,667
Latest member
KWR21

### 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