Excel solution

  Dobie 10:59 26 Feb 06
Locked

Looking for some help with Excel.
Trying to help a friend who is currently sitting his taxi exam.
He has a spread sheet with two columnes of information. Column 1 has the question, column 2 the answer.
Looking for a formula where column 1 still retains the question, column 2 is blank, but if the correct answer is typed in, and enter is pressed, then column three will say correct or wrong.
Is this possible.

Thanks in advance

Linda

  beynac 11:54 26 Feb 06

Whatever is typed into column 2 would have to exactly match the answer for this to work. If it's multiple choice (i.e. the answer is a number or single letter) - no problem. Cell A1 is the question: cell B1 is where the answer is typed.

Formula for cell C1:
=IF(B1="answer","Correct","")

So, for a numerical answer (e.g. 1) it would be: =IF(B1=1,"Correct","")

  Taff™ 11:56 26 Feb 06

How about Hiding Column Two, then filling in the answer in column three. In column four enter a formula that says something like IF(A3=A2,"CORRECT","Try Again") For example you could leave out "try again" and just use "" which would leave the box blank unless the answer was correct which would give CORRECT in the box.

  beynac 11:57 26 Feb 06

I just re-read your post and realised that you wanted column 3 to say "correct" or "wrong". So:-

=IF(B1=1,"Correct","Wrong")

  Kenneth-266656 12:18 26 Feb 06

I take it the question requires a simple yes or no for an answer - if so try this (I've used a stupid question as an example)

Question (In A1) Is Tower Bridge in London

Answer (In B1) yes

Exam Candidates answer (In C1) yes or no

In A1 type in question

In B1 type in answer

In D1 type in
=IF(C1="","",IF(C1=B1,"Correct","Wrong"))

Type in all the questions and answers and then fill down to complete the D column then select the B column and choose Format - Column - Hide

B column will now be hidden - when no answer is typed in C D will be blank. The answer must be yes or no to agree with column B

  Dobie 16:04 26 Feb 06

Thanks guys, your solutions were great, it is working a treat, once again, thanks.

This thread is now locked and can not be replied to.

Hands-on: Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too

47 iPhone camera tips to help you take better photos