Return text not excel address
 

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

Return text not excel address
 

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

Return text not excel address
 

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)


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