Functions across worksheets?

[henrysun909]

So after spending a couple of hours trying to create an interactive worksheet in which Sheet 1 gives the questions and Sheet 2 is the answer sheet.

In sheet 1, column A = question number, B = questions and multiple choice answers (A, B, C, D) and C = the place where the answers are put. These answers are in C1, C6, C11, and C16 (that is, B1 = question, B2,, 3, 4, 5 = answers A, B, C, D respectively, and row 6 = space between questions). I then copy column C, which has the correct answers, to Sheet 2 column C, so that the two columns are identical.

I am trying to use the IF logical function to write the following in sheet 1, cell A1:

=IF(sheet1.c1=c1; correct; try again)

That is, if the answer provided on sheet 1 C1 matches the answer in Sheet 2 C1, then the program is to return "Correct" and if it does not match, the program is to return "Try Again."

I've tried typing this in, using the point and click method, but to no avail - I always get #NAME? as the error message.

I'm about ready to tear what little hair I have left. Can anyone show me what I'm doing wrong here?

Thanks in advance.

Henrysun909

[Ed]

Try putting "Correct" and "Try Again" in quotation marks.

Calc is trying to interpret "Corect" and "Try Again" as functions, but since it doesn't recognise these functions it is returning an error. If you put them in quotation marks, it will treat them as text.

[henrysun909]

Thanks very much! I tried your suggestion this morning and it worked like a charm.

Henrysun909