If correct, add 1

S

sparky3883

Hi all

I'm not too familiar with Excel and was wondering if someone coul
please help me.
I'm creating a small quiz using Excel.
The questions are going to be in Columns A, Row 1 down to 100. What
want to do is to get the user to write the answers into column B an
then if the answer is correct, I want the word 'correct' to appear i
Column C and then the score (which is 1 point for each correct answer
to appear in column D. If the answer is wrong, i don't want anythin
appearing in Column C and no points to appear in Column D.

I undersatnd that this is a big ask but i was wondering if anyone coul
please help me with the coding as i know very little about Exce
coding.

Any help would be much appreciated.
Thanks in advance

Mar
 
B

BenjieLop

sparky3883 said:
Hi all

I'm not too familiar with Excel and was wondering if someone coul
please help me.
I'm creating a small quiz using Excel.
The questions are going to be in Columns A, Row 1 down to 100. What
want to do is to get the user to write the answers into column B an
then if the answer is correct, I want the word 'correct' to appear i
Column C and then the score (which is 1 point for each correct answer
to appear in column D. If the answer is wrong, i don't want anythin
appearing in Column C and no points to appear in Column D.

I undersatnd that this is a big ask but i was wondering if anyone coul
please help me with the coding as i know very little about Exce
coding.

Any help would be much appreciated.
Thanks in advance

Mark
Click to expand...

A simple, no frills solution would be :

1. In another column, say, G1:G100, enter the correct answer
corresponding to the questions in A1:A100. As soon as you have entere
all the answers in Column G, you can hide this colum
(Format/Column/Hide) so that nobody can take a peek at the answers;

2. In Column C1, enter this formula

=IF(B1=G1,\"CORRECT\",\"\") [/B] AND COPY DOWN UNTIL C100


3. IN CELL D1, YOU CAN ENTER ANY OF THESE TWO FORMULAS

*=IF(B1=G1,1,\"\") * OR

*=IF(C1=\"CORRECT\",1,\"\"

Choose any of the above formula that you like and copy down unti
D100.

If you even want to determine the correct scores, =sum(D1:D100)*

Hope this will help you. Regards
 
Top