Using IF to check the cell contents from a drop-down list

I am using Excel 2003

I have made a drop-down list in cell B9 via Date > Validation > List and I would like cell B5 to check the contents of cell B9 and either "Correct" or "Incorrect" depending on which answer to a question the user selects in cell B9.

But =IF(B9= "Answer A", "Correct", "Incorrect") isn't working. B5 won't even display B9 with a simple =B9 statement. How can I do this?

Originally Posted by Fotis1991

This is not normal. Something else happens. Can you upload the sample workbook?

Ok, here it is. It's a simple quiz that will be the basis for a college assignment about HCI. Very early days yet as you can see! But I just want to get it working before I pretty it up. :-)

Hi helen269

Try in B5: =IF(B9=L6,L6,"")

Originally Posted by Fotis1991

Your font color in B5 IS WHITE

Change to black or anything else that you can see it.

OMFG, I am SO embarrassed! That is such a simple bloody mistake.... Needless to say, I am not very experienced with Excel and haven't used it in quite a while. That's my excuse and I'm stuck with it (Laurel and Hardy joke).

Thank you! :-)