ExcelBanter - If correct, add 1

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If correct, add 1 (https://www.excelbanter.com/excel-worksheet-functions/49831-if-correct-add-1-a.html)

If correct, add 1

Hi all

I'm not too familiar with Excel and was wondering if someone could
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 i
want to do is to get the user to write the answers into column B and
then if the answer is correct, I want the word 'correct' to appear in
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 anything
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 could
please help me with the coding as i know very little about Excel
coding.

Any help would be much appreciated.
Thanks in advance

Mark

--
sparky3883
------------------------------------------------------------------------
sparky3883's Profile: http://www.excelforum.com/member.php...fo&userid=6893
View this thread: http://www.excelforum.com/showthread...hreadid=475121

sparky3883 Wrote:
Hi all

I'm not too familiar with Excel and was wondering if someone could
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 i
want to do is to get the user to write the answers into column B and
then if the answer is correct, I want the word 'correct' to appear in
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 anything
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 could
please help me with the coding as i know very little about Excel
coding.

Any help would be much appreciated.
Thanks in advance

Mark

A simple, no frills solution would be :

1. In another column, say, G1:G100, enter the correct answers
corresponding to the questions in A1:A100. As soon as you have entered
all the answers in Column G, you can hide this column
(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 until
D100.

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

Hope this will help you. Regards.

--
BenjieLop

------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=475121