LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP seems correct, still getting #N/A Jazz Excel Worksheet Functions 2 September 2nd 05 06:17 PM
Vlookup, What is correct formula for problem below? Bill R Excel Worksheet Functions 7 August 2nd 05 04:01 AM
Calculation not correct Kevin Excel Discussion (Misc queries) 1 July 22nd 05 04:01 AM
How can I turn auto correct on or off for one column only? jacskier Excel Worksheet Functions 3 June 13th 05 04:55 PM
pmt function in Excel does not return correct monthly payment amou Harraman@Bangalore Excel Worksheet Functions 6 March 3rd 05 01:28 PM


All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"