Rasta

14th February 2008, 07:17 PM

Seeking some help from you Excel (or whatever else you could recommend I use) guru's out there.

Here is my situation:

I have a trial exam that I have done that I want to plot my answers in one column, then the correct answers in the next column, and the third column I want either 1 for a correct answer or 0 for an incorrect answer so I can sum it at the end.

The exam is multi-choice with five answers A, B, C, D, or E.

Ideally I'd like to enter the data as letters, and the correct answers as letters (as I want to be able to manipulate it a little and take out some questions or see what happens if an alternative 'correct' answer is used.

Is there any way to do this easily? I basically need a formula for the marking column of something like

'if A1 = B1 then C1 = 1';'if A1 not = B1 then C1 = 0'

but don't know how to do it - does anyone out there know?

Does that make sense and can anyone understand what I'm trying to do?

Here is my situation:

I have a trial exam that I have done that I want to plot my answers in one column, then the correct answers in the next column, and the third column I want either 1 for a correct answer or 0 for an incorrect answer so I can sum it at the end.

The exam is multi-choice with five answers A, B, C, D, or E.

Ideally I'd like to enter the data as letters, and the correct answers as letters (as I want to be able to manipulate it a little and take out some questions or see what happens if an alternative 'correct' answer is used.

Is there any way to do this easily? I basically need a formula for the marking column of something like

'if A1 = B1 then C1 = 1';'if A1 not = B1 then C1 = 0'

but don't know how to do it - does anyone out there know?

Does that make sense and can anyone understand what I'm trying to do?