Return text not excel address

  • Thread starter Susan On the Boat
  • Start date
S

Susan On the Boat

I need help creating a student test answer report. I want the student's
correct answer returned with a * and their wrong answers returned from the
contents of the excel adress not the adress (their wrong answer should be
diplayed). Thank you for your time and help. Susan

KEY STUDENT I got this far.
B B =IF(ISNUMBER(FIND("B",B2)),"*", "B2")
C D =IF(ISNUMBER(FIND("C",B3)),"*", "B3")
D D =IF(ISNUMBER(FIND("D",B4)),"*", "B4")
D D =IF(ISNUMBER(FIND("D",B5)),"*", "B5")
B A =IF(ISNUMBER(FIND("B",B6)),"*", "B6")
C C =IF(ISNUMBER(FIND("D",B7)),"*", "B7")
E A =IF(ISNUMBER(FIND("E",B8)),"*", "B8")
 
E

Elkar

To reference the contents of a cell, do not enclose it in quotes.

=IF(ISNUMBER(FIND("B",B2)),"*",B2)

Although, you could probably shorten your formula to:

=IF(A1=B1,"*",B1)

HTH
Elkar
 
J

JLatham

Change the final cell references you have in the formula to get rid of the
double-quotes. Example for the first formula:

=IF(ISNUMBER(FIND("B",B2)),"*",B2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top