Try this:
=If(E9="Yes","What is your Student Number?", "")

Regards,
Stefi

€žFordFiestaST150€� ezt Ã*rta:

I am busy typing up a Application Form. Cell E9 contains drop-down of either
Yes or No. If user selects Yes I need text to be displayed in Cell E11 and
nothing to displayed if No is selected.
Tried following formula: =If(E9,"What is your Student Number?", " ") and it
returned a Value Error.