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