Formula Help Needed

  • Thread starter FordFiestaST150
  • Start date
F

FordFiestaST150

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.
 
S

Stefi

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

Payment calculation 1
Help with Formula 3
Drop down list control value in vba 2
SUMIF with OFFSET 5
SUMIF with multiple criteria 5
Formula 6
LOOOOONG formula, with drop down selection 1
help with formula 2

Top