This is simple I just know it.... Please Help.......

[jroo888]

Students are to answer questions....
The answers are simply Choice1A-D
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.

 

[MARK858]

Are you sure you have no leading spaces in the cell?

Try

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

 

[jroo888]

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

 

[MARK858]

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

 

[jroo888]

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