View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FordFiestaST150 FordFiestaST150 is offline
external usenet poster
 
Posts: 1
Default Formula Help Needed

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.