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?
|