Formula Help Needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try this:
=If(E9="Yes","What is your Student Number?", "")

Regards,
Stefi

„FordFiestaST150†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"IF" confusion 3
Help with Formula 3
TIMECALC Formulas 2
Formula 6
Payment calculation 1
average & iserror formula 3
Array Formula Question 6
help with formula 2

Back
Top