View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teresa
 
Posts: n/a
Default Creating a form in excel to step through scenarios

I'm wanting to creat a form in excel that will allow the user to step through
a series of questions, each one dependant on the previous, in order to work
out which process out of 5 different options they need to follow.

Eg: is customer a company or individual?
If Company selected next question to display will be "Do they want to change
name or close account?" etc etc

What sort of formulae do I need to use to do this?