**Question description:**

*This user has given permission to use the problem statement for this blog.*

I want to create a form, where if I ask question one and the answer is a particular thing it will automatically ask another question. i.e. are you male or female. If female then the next question would be are you pregnant? however if male is answered I don't want the other question to be shown. Can anyone help?

Solved by O. Q. in 34 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
28/06/2018 - 09:41

Welcome to ExcelChat!

User
28/06/2018 - 09:41

thanks

Excelchat Expert
28/06/2018 - 09:42

Could you describe in which format do you want to see your form?

User
28/06/2018 - 09:42

I would like it printable, but ultimately questions in column one and answers in column 2 etc

User
28/06/2018 - 09:43

but there are questions that wont refer to everyone, i.e. if they are male I want it to pop up with different questions to female based on their answer

Excelchat Expert
28/06/2018 - 09:44

Okay, could you copy here your questions?

Excelchat Expert
28/06/2018 - 09:44

Can you see the preview document?

Excelchat Expert
28/06/2018 - 09:45

It should be next to your chat

User
28/06/2018 - 09:45

if its possible to show me just how to do it once I can do the rest, just didn't know where to start

Excelchat Expert
28/06/2018 - 09:45

Yes, I can do it

User
28/06/2018 - 09:45

thanks

Excelchat Expert
28/06/2018 - 09:45

Do you see the preview window near the chat?

User
28/06/2018 - 09:45

yes

Excelchat Expert
28/06/2018 - 09:45

Great

User
28/06/2018 - 09:45

theres nothing in it at the moment

Excelchat Expert
28/06/2018 - 09:45

So I will make an example

Excelchat Expert
28/06/2018 - 09:46

Do you have access to the google documents?

User
28/06/2018 - 09:46

yes should be able to through my phone, cant on this work pc

Excelchat Expert
28/06/2018 - 09:46

Okay.. so you can't see what I am showing

Excelchat Expert
28/06/2018 - 09:47

I will then send you a file with a solution

User
28/06/2018 - 09:47

no

User
28/06/2018 - 09:47

thanks

User
28/06/2018 - 09:54

will I receive it as an email?

Excelchat Expert
28/06/2018 - 09:55

No, I will send it as attachment soon, and I will also provide the explanations

User
28/06/2018 - 09:57

thanks

Excelchat Expert
28/06/2018 - 09:58

Here is your file

[Uploaded an Excel file]

Excelchat Expert
28/06/2018 - 09:58

Please extend the session so I had time to explain it to you

Excelchat Expert
28/06/2018 - 09:59

Thank you

Excelchat Expert
28/06/2018 - 09:59

So in the file, we have column A-C, where you can indicate the possible answers for the questions

User
28/06/2018 - 09:59

it says the file is corrupt?

User
28/06/2018 - 09:59

could you try sending again

Excelchat Expert
28/06/2018 - 09:59

One minute

Excelchat Expert
28/06/2018 - 10:01

[Uploaded an Excel file]

Excelchat Expert
28/06/2018 - 10:02

Does it work?

User
28/06/2018 - 10:02

is it possible to have it e-mailed as I'm struggling to download it?

User
28/06/2018 - 10:02

or shared on google docs?

Excelchat Expert
28/06/2018 - 10:03

I can't send it with email to you, because it is forbidden by our rules.. and it seems like google docs are blocked for you

Excelchat Expert
28/06/2018 - 10:04

I can send you a screenshot where you will see the formulas

User
28/06/2018 - 10:04

yes pelase

User
28/06/2018 - 10:04

sorry, I thjink its a work pc problem

Excelchat Expert
28/06/2018 - 10:04

yeah, I have been in such situation too

Excelchat Expert
28/06/2018 - 10:05

[Uploaded an Excel file]

Excelchat Expert
28/06/2018 - 10:05

Please have a look

User
28/06/2018 - 10:05

that works thanks

Excelchat Expert
28/06/2018 - 10:06

Columns A, B, C - here you indicate the possible answers for the question

User
28/06/2018 - 10:06

ok

Excelchat Expert
28/06/2018 - 10:06

Columns K, L, M - here you indicate the trigger answer, which will shown additional question

User
28/06/2018 - 10:06

brilliant

Excelchat Expert
28/06/2018 - 10:07

Column H contains the Data Validation - it allows to pick only answers from A, B, C - you just need to extend the formula down and it will work for the new questions

Excelchat Expert
28/06/2018 - 10:07

When you need to add a question with condition, you type the formulas which are in E3 and F3

Excelchat Expert
28/06/2018 - 10:07

They check if answer meets the trigger, if yes - it shows the questions, if no - it shows nothing

User
28/06/2018 - 10:08

ok I think I get it

Excelchat Expert
28/06/2018 - 10:08

I made it easy to modify and add questions, conditions etc

User
28/06/2018 - 10:08

thanks so much for your help

Excelchat Expert
28/06/2018 - 10:08

all you need to do - is to extend the cell with user Answer, and copy those formulas for questions with conditions

Excelchat Expert
28/06/2018 - 10:08

Hope it will help you

Excelchat Expert
28/06/2018 - 10:09

Sorry that we couldn't show it in a better way

User
28/06/2018 - 10:09

ok I'll have ago, thanks again and apologies I couldn't get our system to work

Excelchat Expert
28/06/2018 - 10:10

Have a great day!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*