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


"Susan On the Boat" wrote:

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")