View Single Post
  #1   Report Post  
sparky3883
 
Posts: n/a
Default 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