Return text not excel address

  • Thread starter Thread starter Susan On the Boat
  • Start date 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")
 
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
 
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)
 
Back
Top