Home |
Search |
Today's Posts |
#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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP seems correct, still getting #N/A | Excel Worksheet Functions | |||
Vlookup, What is correct formula for problem below? | Excel Worksheet Functions | |||
Calculation not correct | Excel Discussion (Misc queries) | |||
How can I turn auto correct on or off for one column only? | Excel Worksheet Functions | |||
pmt function in Excel does not return correct monthly payment amou | Excel Worksheet Functions |