Dependent Questions Based on Answers

[oua]

Hello everyone,
I am really stuck. I am trying to set up a series of questions where a "yes" or "somewhat" response opens up a new question and a "no' answer leads the person being questioned to the next set of questions in a new row. Is there any way I can do this in excel? or do I need advanced programming knowledge to accomplish this task?
I do not know anything about macros or VBA...so if anyone has a suggestion that contains this thread, the answer would have to be really detailed in order for me to follow.
I appreciate any suggestions. Currently I am working with If...then function. I can manage to either display the next question or not by simply using yes or no, but I cannot get somewhat into the equation. Also, I cannot figure out how to prompt the person being asked to continue with the next set of questions in a new row if the answer is no.
This is the function I am currently using for all questions to continue to the next question:

=IF(B3="Yes"," 2. Is this course objective assessed?","")

Thanks,
Christina

[Andrew-R]

This is a massive, massive question.

The easy part is if you want to check for "yes" or "somewhat" with your formula then you could use:

Please Login or Register  to view this content.

Unfortunately, as you've found out, this doesn't really get you very far.

It's possible to get Excel to do some really useful things with just formula, but the formula involved are quite complex, so it's generally done with VBA.

However, I've attached a fairly simple system to set up questions with a Yes/No/Somewhat option and route to new questions depending on the answers. You're welcome to use it if it helps you, or you can adapt it for your own needs (but some of the formula are a bit complex, sorry).

[RMHF]

that's perfect, thanks! Just what I was looking for internally.